F5SpecialVisible cell onlyOK

Copy and paste.


Gord Dibben MS Excel MVP

On Thu, 10 Dec 2009 11:01:02 -0800, beana
wrote:

how do you paste only shown rows on a spreadsheet to a new workbook? I have
hidden rows that I do not want to copy over. thanks!
i am working in office 2007