Thread: For each next
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kaval Kaval is offline
external usenet poster
 
Posts: 23
Default 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