copy only unhide columns

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
 
C

Cesar Zapata

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
 
D

Dean Collins

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

Cheers,
Dean
 
Top