Nope. You're looking After:= a cell.

But you could find "Equity" first, then look after that found cell.

dim FoundEquity as range
dim FoundWord as range

with activesheet
set foundequity = .cells.find(what:="equity", .....

if foundequity is nothing then
msgbox "Equity wasn't found!"
else
set foundword = .cells.find(what:="word", after:=foundequity, ...

end if
end with



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

--

Dave Peterson