VBA requirement for searching string that begines with...

[omairhe]

Hey all,

In need of a simple code that will search string in Column A that begins with "BEL" . Once searched goto target.row.

Will appreciate any help.

Thank you.

 

[omairhe]

Just would like to post slightly altered code because the searches may miss once changed to formulas or comments from within Ctrl F.

Sub omairhe()
   Dim Fnd As Range
   Set Fnd = Range("A:A").Find("BEL*", , [COLOR=#ff0000][B]xlValues[/B][/COLOR], xlWhole, , , False, False)
   If Not Fnd Is Nothing Then Cells(Fnd.Row, ActiveCell.Column).Activate
End Sub

source: https://www.youtube.com/watch?v=nV_oDWJccu8