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,<font size=+2><font color="red"> I<font color="blue">van<font color="red"> F M</font color="blue">oala</font><MARQUEE>Have a Nice day

</MARQUEE>
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