Tom,

Great work as always. I had to use ReferstoRange.Value to actuall
get to work (xp03 if it makes a difference). But again all credit goe
to you !!!!!

Thank you very much
Jo

--
Joe
-----------------------------------------------------------------------
JoeH's Profile: http://www.excelforum.com/member.php...fo&userid=1413
View this thread: http://www.excelforum.com/showthread.php?threadid=26346

Misunderstood that Test referred to a cell. Thought the name test contained
the value of for CL

Name: Test
RefersTo =25

So you did the right thing with ReferstoRange, but you don't need the
evaluate (if you still used that)

cl = workbooks("TestCalcs_rev22.xls").Names("Test").Ref erestoRange.Value

--
Regards,
Tom Ogilvy


"JoeH" wrote in message
...

Tom,

Great work as always. I had to use ReferstoRange.Value to actually
get to work (xp03 if it makes a difference). But again all credit goes
to you !!!!!

Thank you very much
Joe


--
JoeH
------------------------------------------------------------------------
JoeH's Profile:
http://www.excelforum.com/member.php...o&userid=14138
View this thread: http://www.excelforum.com/showthread...hreadid=263468