Tom,

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

Thanks for putting me on the right track
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