Hi,

I want to highlight the text within a box on the active sheet and fin
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) bu
either can't paste the cell's value into the find box or if I go int
the cell and copy and paste the text into the find box it does th
exact same search everytime.

Thanks a lot!

Wil

--
MrMerto
-----------------------------------------------------------------------
MrMerton's Profile: http://www.excelforum.com/member.php...fo&userid=1096
View this thread: http://www.excelforum.com/showthread.php?threadid=39866