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