I want to have a loop over spreadsheet columns and rows and perform some action for a certain cell value.
Something like:
for each cells: if cellValue = "abc" then do: //Do something end. end.
I can't use range directly like this:
chWorksheet:Range("B1"):VALUE.
Because I need dynamic position of the cell.
I found some code in VB:
For Each c in Worksheets("Sheet1").Range("A1:D10") If c.Value < .001 Then c.Value = 0 End If Next c
Is there a similar way in Progress?
Thanks.
Worksheets("Sheet1"):Cells(<row>, <col>):Value
Worksheets("Sheet1"):Cells(<row>, <col>):Value