I have a range of cells I need to copy. there is s blank row underneath the last populated cell of the column and then data I do not need. I have been using range(B3:B) in my copy script but it gets everything in column B including hopping the blank row and getting the data I don't need. How can I stop the dynamic range dead when it hits the empty row?
Here is a sample of my code.
Please Login or Register to view this content.
Bookmarks