before you use cl use

cl = Evaluate(workbooks("TestCalcs_rev22.xls").Names("T est").Referesto)

Changing the name to TestCalcs_rev22.xls to the appropriate workbook.
--
Regards,
Tom Ogilvy

"JoeH" wrote in message
...

Tom,

I tested taking out the CL value and actually hard coding a row and
it worked. Now in reference to my above question, i named a cell test
and wrote the value of CL into it. Now how do i retrieve that value and
use it in the code in the place of CL ........ rows(cl) needs to be
rows( what ever is in cell test ).

Thanks for putting me on the right track
joe


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