Search Question

[Roy Lasris]

I have a formula that accurately finds the existence of a term, but I need to
know in which cell the the term was found. Here is the formula:

foundit = Cells.Find(what:="ABC")

How can I determine the cell that "ABC" was in, and if it exists in any other
cells as well. Thanks.

Roy

 

[Frank Kabel]

Hi
try
msgbox foundit.address

 

[Tom Ogilvy]

Maybe a little more:


Dim foundit as Range
set foundit = Cells.Find(what:="ABC")

if not foundit is nothing then
msgbox foundit.Address
else
msgbox "Not found"
End if

 

[Dave Peterson]

And you may want to specify all the parms that go with .find.

Excel will try to help you by using the last ones that were specified--the stuff
hanging around may not be what you really want.