Tom,

i tried that and now i get a 400. no description or anything.
looked on the MS site and it says something about showing a form o
module ??? is this error due to CL not being defined properly o
already in use by something else ??

Thanks
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

I ran your code from a userform and had no problem with it.

Try closing excel and rebooting. Then see if it works.

I have run into the 400 error as well - it seems to occur intermittently,
but rarely and usually isn't a consistent error.

CL must be visible, but you will get a 1004 error if it isn't.

--
Regards,
Tom Ogilvy

"JoeH" wrote in message
...

Tom,

i tried that and now i get a 400. no description or anything. I
looked on the MS site and it says something about showing a form or
module ??? is this error due to CL not being defined properly or
already in use by something else ??

Thanks
Joe


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