Excel Search Assistance

[hsmit007]

I have 600 rows that have unique names. I've created a search function that highlights the name from the search box, but I'm seeking assistance for excel to go to the highlighted cell row. Currently, I have to scroll down to the highlighted row from the search. Any assistance is appreciated.

 

[MrKowz]

Can you please post your existing code? The way we get to the desired cell/row is dependent on how you are currently finding it.

 

[hsmit007]

I have 600 rows that have unique names. I've created a search function that highlights the name from the search box, but I'm seeking assistance for excel to go to the highlighted cell row. Currently, I have to scroll down to the highlighted row from the search. Any assistance is appreciated.

The search code ="IF(ISBLANK(Search_box),0,SEARCH(Search_box,$A6:$A608))" The code is in the conditional formatting for the cell range.

 

[MrKowz]

We can't use a formula to tell Excel to go to a specified range (I had assumed you did this through VBA). Are you okay to use a VBA solution for this?

Try:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range
If Not Intersect(Target, Range("Search_Box")) Is Nothing Then
    With Range("A:A")
        Set rng = .Find(Target.Value, LookIn:=xlValues, lookat:=xlPart)
        If Not rng Is Nothing Then
            'value found
            rng.Select
        End If
    End With
End If
End Sub

 

[hsmit007]

I can use VBA and will give that a try. Thanks for your assistance!!

 

[MrKowz]

I can use VBA and will give that a try. Thanks for your assistance!!

Cheers - let me know if you need any instructions on where to place the code.