copy a page with hidden rows and only paste what is showing

[Guest]

I am trying to find out how to copy an excel spreadsheet with hidden rows and
paste onto another sheet only what is showing so I do not have to continually
deal with the hidden rows.

 

[Don Guillett]

have a look in the vba help for SPECIALCELLS, especial XLVISIBLE

 

[Gord Dibben]

Select the range then F5>Special>Visible cells only>OK

Copy then paste.


Gord Dibben MS Excel MVP