Pasting Visible data only

[Peter100]

I have a worksheet that has hidden columns and I want to copy and paste only the visible data, is this possible ?

[Ivan F Moala]

On 2002-05-04 15:31, Peter100 wrote:
I have a worksheet that has hidden columns and I want to copy and paste only the visible data, is this possible ?

Just select the range to copy.

Select from Menu: Edit > Goto > Special

Then select Visible cells Only in the Goto
box.

Press Copy then goto the area you want to paste and Paste.

You should only have the Visible cells


_________________

Kind Regards,
Ivan F Moala
Have a Nice day

[ This Message was edited by: Ivan F Moala on 2002-05-04 15:41 ]

[SamS]

Peter the vba code for this is
Selection.SpecialCells(xlCellTypeVisible).Select
ActiveSheet.Paste