Yes. Instead of using 'Cells' as the range in the Find call, which is
the entire worksheet, you can specify any range in which it will search
in. So Range("A2:A500").Find("word", .. , should work. Be careful
with the find since it saves the settings for all the arguments it uses
each time. Always a good idea to just set them to what you need each
time. The help menu gives some good explanations.

CarolineHedges wrote:
Can you chose to look for a word *before* something, aswell as after:
Cells.Find("word", After:=Equity..............

If not how I can i get around it, can i ask it to search within a range
on a worksheet? ie within range A2:A500?


--
CarolineHedges
------------------------------------------------------------------------
CarolineHedges's Profile: http://www.excelforum.com/member.php...o&userid=35705
View this thread: http://www.excelforum.com/showthread...hreadid=566967