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 rang
on a worksheet? ie within range A2:A500

--
CarolineHedge
-----------------------------------------------------------------------
CarolineHedges's Profile: http://www.excelforum.com/member.php...fo&userid=3570
View this thread: http://www.excelforum.com/showthread.php?threadid=56696