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

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.

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

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

--
Don Guillett
SalesAid Software

"wyocowboy" wrote in message
...
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.

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

Select the range then F5SpecialVisible cells onlyOK

Copy then paste.


Gord Dibben MS Excel MVP


On Sat, 18 Nov 2006 10:37:01 -0800, wyocowboy
wrote:

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.