Good day, hope someone can help me with a challenge I'm facing. I have recently started on VBA and have come across the following problem:

The VBA code to copy non-hidden range data from one worksheet, and paste to another worksheet is generally working. But the problem I have come across is that the destination sheet
has a header row and below that nothing but hidden rows. I would like the destination row to paste to to be the first row after the header row, which is basically the first visible row after all the hidden rows. The last row function will get me to the header row, but Lr + 1 is getting Excel/VBA to paste to the next HIDDEN row.

So far, the code I have is only working when I unhide the rows in the destination sheet first.

Can Excel/VBA paste to the next visible row??

Hope to get your solution, if any.

Best regards, MaQian.