Hi, I'm filtering visible cells from one sheet and pasting them into another in a loop.
Each time I go back to the first sheet I filter the next column and select the new cells, which I then paste into a different section of the second sheet. I do this three times moving across then move down 20 rows and repeat. The problem I'm having is handling the error I get when there are no cells to select. Also I'm missing something as I don't seem to be able to move down the required rows before restarting.
Here's the code:
Bookmarks