| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
