copying a column

[matrickz]

I created a document with hidden rows. I now want to copy a column from that report but NOT show the hidden rows. Highlighting the column brings over the entire column. I know I can click on each cell but we are talking 900 cells. How can I copy over JUST the cells that are SHOWING?

 

[Datsmart]

You can use the following code to do it:

    Columns("C:C").SpecialCells(xlCellTypeVisible).Copy _
        Destination:=Sheets("Test 2").Range("A1")

This copies column C to the WorkSheet called "Test 2", column A.
The hidden rows are not copied.

To do this manually:
Select the Column
Hit Alt-;
Ctrl-C to copy
Ctrl-V to Paste where you want.

 

[matrickz]

you are a saint my good man. Thanks a ton for the help!