How To Move to First Row of Filtered Data-

njschultz

New Member
Joined
Dec 1, 2020
Messages
1
Office Version
  1. 2019
Platform
  1. Windows
-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?
 

Attachments

  • BoB Redistrib_gotoTopofPage.JPG
    BoB Redistrib_gotoTopofPage.JPG
    217.5 KB · Views: 6

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

fadee2

Active Member
Joined
Nov 7, 2020
Messages
336
Office Version
  1. 2019
Platform
  1. Windows
hi njschultz,
Welcome to the board.

This is exactly what you need.
HTH...
 

Watch MrExcel Video

Forum statistics

Threads
1,127,521
Messages
5,625,295
Members
416,087
Latest member
drth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top