Skip hidden rows when pasting data..

[inahs2k]

Hi all,

I need some help regarding an issue that I have run into.

Say I have copied a range of cells and I want to paste it in another range but the catch is: I might have some hidden rows in the destination range and I want to skip those hidden rows when pasting this data. Is it possible to skip some hidden rows in the destination range when pasting the copied data. I tried looking at the paste special function but I could not find anything that would skip the hidden rows when pasting. I dont know if it is even possible, but if it is then it would be a great help.

Any help in this regard would be most welcome.

Thanks in advance and have a nice day.
Shahnaz.

 

[Pcfred]

you're not really hiding rows, you're actually just changing the row height to 0. So maybe some kind of looping function using something like this.


If ActiveCell.RowHeight = 0 Then ActiveCell.Offset(1,0)=Your Data