Hi Guys,
I need a code which will take a lump of data, B2:AW366 and cycle through the data in a single cell (A1)
So to clarify Cell A1 should cycle through:
B2
C2
D2
E2
...
...
...
AU2
AV2
AW2
B3
C3
D3
E3
.....
.....
Continue until cell AW366 reached.
If possible i would like the speed of the cycle to be variable, So i can select a 0.5 second delay before Cell A1 changes to the next reference.
Many Many Thanks
Bookmarks