sh.Cells.Find()

[Dan R.]

I'm using the following to search for values in multiple worksheets.
Is there a way to specify which column it looks in to speed up the
code a bit?


For Each sh In bk.Worksheets
For Each i In iRng
Set rng = sh.Cells.Find( _
What:=i.Value, _
LookIn:=xlValues, _
Lookat:=xlWhole, _
MatchCase:=False)


' Do Stuff

Next i
Next sh


Thanks,
-- Dan

 

[Guest]

Set rng = sh.Range("A1:A10000").Find(i.Value, LookIn:=xlValues)

"Dan R." skrev: