How To Move to First Row of Filtered Data-

[njschultz]

-What I have (see attached image)
I have a spreadsheet with a tab where the data is filtered by slicers.

-What I Want To Have
When a user selects their data and scrolls down a ways - I'd like them to be able to click a macro button that returns them to the first line of filtered data.....and selects that left most cell in the data ("PPID")

-Tried active window etc. and nothing to seem to work....
Sub TopofPage()
ActiveWindow.ScrollRow = 1
End Sub

Is there a way to select the first row cell of the "PPID" column of the filtered data?

 

[fadee2]

hi njschultz,
Welcome to the board.

This is exactly what you need.
HTH...