I may be misunderstanding, but how about
:
Code
-------------------
Sub test()
Dim r As Range
Dim strFind As String
strFind = Range("B13").Value
For Each r In Range("E13:F22")
If r.Value = strFind Then
r.Select
Exit For
End If
Next
End Su
-------------------
--
Message posted from
http://www.ExcelForum.com