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.
Thanks for the help.
Bookmarks