Runtime error 13 type mismatch ?
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 |
Runtime error 13 type mismatch ?
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 |
All times are GMT +1. The time now is 06:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com