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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to retrieve records ... need help, thanks. 6
excel multiple files saved in 1 file 26
I copied Visible Cells Only, but it pastes only the first cell 1
Unable to unhide hidden columns 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How to matching substring from a Cell 4
Automate mail 1
Unhide in a macro 6

Back
Top