none
Use Ctrl+ F & scroll to the top RRS feed

  • Question

  • Hi, can anyone tell me if there is a way of using Ctrl + F and then have the row containing the found cell automatically displayed at the top of the data set

    Thanks

    Wednesday, July 11, 2018 6:33 AM

All replies

  • You asked this in the VBA forum, so I'll reply using VBA. The Application.GoTo method lets you do this:

        Dim rng As Range
        Set rng = Cells.Find(What:="something", LookAt:=xlPart, MatchCase:=False)
        If Not rng Is Nothing Then
            Application.Goto Reference:=rng, Scroll:=True
        End

    If the text "something" is found, the (first) cell containing this text will be in the upper left corner of the window.


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Wednesday, July 11, 2018 8:09 AM