none
Macro to Navigate to Top Row of Filtered Result Set RRS feed

  • Question

  • I have a worksheet with top 2 rows reserved for buttons and filter header.

    If i have filtered rows so that row 3 is no longer visible (filtered out), and some other row is in the 3rd row position, and i have paged down several pages, what is the button macro to return to the top of the worksheet (logical row #3, not physical row #3)

    Thanks in advance.

    Thursday, October 22, 2015 9:37 PM

Answers

  • Re: my place is three rows down

    Try...
    Sub MoveHome()
      Dim Rw As Long
      ActiveWindow.ScrollRow = 1
      Rw = ActiveWindow.VisibleRange.Row
      ActiveWindow.ScrollRow = Rw + 2
    End Sub

    '---
    Jim Cone
    Portland, Oregon USA
    https://goo.gl/IUQUN2 (Dropbox)
    (free & commercial excel add-ins & workbooks)

    • Marked as answer by BlackTruck Friday, October 23, 2015 1:13 AM
    • Edited by James Cone Saturday, October 22, 2016 5:09 PM
    Friday, October 23, 2015 1:07 AM