Select fist visible cell underneath the header of a filtered data range

[Lacherlich]

Hi.

I know there have been similar posts about this, so apologies, but they all seem too specific to people's own reports etc...

Essentially I am copying data from multiple sheets of data after a filter is applied and pasting them into my main spreadsheet. I am struggling to work out how to select the first cell underneath the header if a filter is applied, so I can then select end down, and copy etc etc.

There might be an easier way to do this rather than selecting etc, but can someone please help with my query,

Many Thanks!

 

[somesoldiers]

apply your filter and copy only the visible rows post filter

adjust B:B and destination to suit your data

Range("B2:B" & Cells(Rows.Count, "A").End(xlUp).Row).SpecialCells(xlCellTypeVisible).Copy _
    Sheets(1).Range("A1")

 

[Lacherlich]

Hey, perfect thankyou!!

This is why I love MrExcel...

 

[somesoldiers]

glad to help