Thanks Cripbd for your reply, i don't know whether that will work a
when i try to run my Auto_open i get a runtime error 13 type mismatc
in the Msgbox line where i have cccount it shows error 2015 when th
cursor is placed over it......any ideas?


Simo

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=27633