For each next
I have a macro that cycles through each cell in a range, eg
for each CELL in RANGE
This seems to work OK until I include something in the code that changes the
value of CELL, and then the macro just ends at that point.
I have tried declaring CELL as a range but no success.
Any clues as to why this might happen?
Regards, Kaval
|