copy only unhide columns

  • Thread starter Thread starter seanyeap
  • Start date Start date
S

seanyeap

Dear Sir/Madam,
I need to how do I copy all values in a worksheet EXCEPT hidden column
and paste them into a new workbook.

Regards,
sea
 
Sean,


Select your columns even the hidden ones. then press F5 click on
"special" then click on visible cells only then do your copy and pasting.


Regards,

Cesar zapata
 
wow you guys are amazing, thanks for that one, I kow I'll use it sometime.

Cheers,
Dean
 
Back
Top