Try the below macro...

Sub Macro()

Dim varRange As Range
Dim varFound As Variant, varSearch As Variant
varSearch = "jacob"
Set varRange = ActiveSheet.Range("A1:J20")
'Replace xlPart with xlWhole if you need a whole cell match
Set varFound = varRange.Find(varSearch, lookat:=xlPart)
If Not varFound Is Nothing Then varFound.Activate

End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Wes_A" wrote:

Hi all, Using Excel 2007 Macro I need to look up a part number (variable) in
an array containing all part numbers and select & activate the cell in the
array where it is found.
Can anyone help?