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