Changing my code to loop through a list of cells (lots of reference cells)

Hi All,

I built a piece of code that does the exact job i want once, but i need it to loop through a range and continue the process until the range is empty.

For the sake of simpleness and because i want to learn i won't provide the whole code, but if i have this set up how would i get each of these ranges to move down by 1 cell each time untill the loop is complete:

The range that starts in 47, 3 or AU4 in sheet terms should go down by one make sure its not blank and if its not everything else should move down in line with it.

Please Login or Register  to view this content.

Thanks for the help.

Hi you are correct i meant to use 3, 47. what would you suggest i do it without selection?

regards,
Joshua

Ah sorry i misread what you had written.
Thanks for the pointers!