Select visible column data after AutoFilter

[pkew22]

I am using Excel 2010.

How does one select the data in a column after it has been filtered with the help of AutoFilter? I would like to select the visible cells in Column F because the records that are filtered have to be in Blue Font and Bold.

I have 30 odd columns and 412 rows of data and I have filtered Column F by recording a macro.

After the filter is applied, the first visible row is 17. This changes depending on what is filtered.

How can I select F17 to the last cell with the help of VBA? (What I would really like to do is select the first visible cell to the last visible cell in Column F and both change on a daily basis.)

Help would be greatly appreciated.

 

[XLfriend777]

Hi pkew22 - You might try the code below which takes the visible cells in Range("A1:D20") and copies them to the Destination Ranges starting at F1. Hope this helps.

Sub pkew22_Copy_Paste_Visible()
Range("A1:D20").SpecialCells(xlCellTypeVisible).Copy _
    Destination:=Sheets("pkew22").Range("F1")
End Sub

 

[pkew22]

Thanks for your time and help, Goesr. Getting the visible cells will work.