Help - loop through cells in a range that are not together (several different cells as Target)
Damn you, Tom. Why does it look so easy for you...-)
Working all right, of course
Thanks you
/Regards
"Tom Ogilvy" skrev i meddelandet
...
for each cell in Target
Next
--
Regards,
Tom Ogilvy
"Marie J-son" wrote in message
...
Hi,
I'm stuck. I need to loop through each cell with my code and get range
error. I belive it is because the range consist of cells that are not
together.Right?
Actually, the event is when you copy one cell and select a number of
others
and paste - dadaam, all cells have the same value as the copied cell. I
use
Worksheet_change event and now I need to run some code with each cell in
Target.
How to do that?
/Kind regards
|