Thanks for the reply Bob

If I am understanding you correctly you are asking if i have declared
the variable as Public?

If so yes i have if not could you give me a little more detail?

Thanks

Adrian


--
SandyUK
------------------------------------------------------------------------
SandyUK's Profile: http://www.excelforum.com/member.php...o&userid=17487
View this thread: http://www.excelforum.com/showthread...hreadid=547362