-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?
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?