Bill_Biggs
Well-known Member
- Joined
- Feb 6, 2007
- Messages
- 1,216
I have a range of cells with data in each cell. The range is from C3 to S23. The data is coordinates to cells on another sheet. I need to create a macro that will go to the range, pick out the first coordinate, execute a function, then go back and select the next coordinate, execute a function and so on through all 357 coordinates. Can anyone show me a small macro that will do that? Something like:
Range(C3, C4, C5, C6... S23)
Pick first coordinate,
Excute function at coordinate
Go back to range and pick next coordinate
Excute function at coordinate...
At end of Range, exit sub
I have the execute portion of the macro down.
Thanks in advance,
Range(C3, C4, C5, C6... S23)
Pick first coordinate,
Excute function at coordinate
Go back to range and pick next coordinate
Excute function at coordinate...
At end of Range, exit sub
I have the execute portion of the macro down.
Thanks in advance,
Last edited: