Brian,

I should have taken that out. This was from a larger macro. It has no
bearing on this routine. Sorry about the confusion.

Also, there is another change needed. Change "Dim rngA, rngB As Range" to
"Dim rngB, rngC As Range". rngB will be the text you are looking for in
rngC.

Is everything on the same sheet or separate sheets/Workbooks? That will
make a difference in how it needs to be modified.

--
Best wishes,

Jim


"Brian Matlack" wrote:


Jim:
Thanks for your response! I'm pretty green about this VBA stuff but
I'll try to tweek it to fit my job. I couldn't tell where the res
Variant was used in your code. I believe it would be what I was looking
for (range name1) in the find part of the code. If you have time to
respond I could use the help, if not I do appreciate the input and I'll
try to make it work.

Thanks Again!!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=562605