How to increment cell in loop

[help000]

If I had

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

How do I increment the cell so that each time in a loop such as

Please Login or Register  to view this content.

the value C56 automatically changes to C57 instead of overwriting C56.

Any help I would appriciate it. Not an expert at loops.

Thanks in advance

[dominicb]

Good afternoon help000

Quite a few ways. Perhaps the simplest would be to identify the cell using the .Cells command, thus :

Please Login or Register  to view this content.

HTH

DominicB

[help000]

Works Good, one quick question if you don't mind, why does it put the value in C 45 to C 49, how do I change this if I wanted to make the same loop but to get it from a different value. How do I change this to B 45 to B 49?