View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default How do I NOT copy hidden rows to a new worksheet?

EditGo ToSpecial, check Visible cells only before you Copy

--
Kind regards,

Niek Otten

"Steve" wrote in message
...
I have a large spreadsheet and have hidden rows. I do not want to copy
the
hidden rows into a new spreadsheet. How do I do that?