What do you men by a box on the active sheet?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"MrMerton" wrote in
message ...

Hi,

I want to highlight the text within a box on the active sheet and find
that text anywhere (or within a range) on the inactive sheet.

I have tried recording a macro for it (i'm not very good with VBA) but
either can't paste the cell's value into the find box or if I go into
the cell and copy and paste the text into the find box it does the
exact same search everytime.

Thanks a lot!

Will


--
MrMerton
------------------------------------------------------------------------
MrMerton's Profile:
http://www.excelforum.com/member.php...o&userid=10962
View this thread: http://www.excelforum.com/showthread...hreadid=398663