Copy and Paste Hidden Columns to New Worksheet

[apinel]

I would like to copy and paste data to new worksheet and keep the hidden columns hidden in the new worksheet. When I paste, the hidden columns become visible. I would also like to know how to copy and paste into new worksheet only the visible data (not hidden columns), so the data in the hidden columns is erased when pasting to new worksheet. Thank you.

 

[Smitty]

Welcome to the Board!

For the first you can use Edit-->Paste Special-->Column Widths.

For the second you can use Goto-->Special-->Visible Cells Only, then copy & paste.

HTH,