how to use find() to search in the selected columns?
 

how to set the parameters like LookIn, Lookat or any others?

how to use find() to search in the selected columns?
 

Try something like the following:

Dim FoundCell As Range
Set FoundCell = Selection.Find(what:="something",
LookIn:=xlValues, _
lookat:=xlWhole, MatchCase:=False)
If FoundCell Is Nothing Then
' not found
Else
' found
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"lvcha.gouqizi" wrote in message
oups.com...
how to set the parameters like LookIn, Lookat or any others?