Hi. I have the same problem. What I need is that I have a serie of # in a
row and in the first row I have a cell that I wrote a # and with Vlookup I
can know in what row is that #. Now what I want is to create a macro so when
I press it it will take me to that row where that # is. Can anybuddy help me
with this??

"Bob Phillips" wrote:

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