Brendon,
Thanks for your reply.

I am having a problem with it.
Error 9
Subscript out of range

at this line
Range("J2") = myArray(0)

I have not been able to determine what is causing the problem
but I think it has somthing to do with the declaration of myArray
Should it be Dim inside the sub or should it be public or global ?


--
swieduwi
------------------------------------------------------------------------
swieduwi's Profile: http://www.excelforum.com/member.php...o&userid=21962
View this thread: http://www.excelforum.com/showthread...hreadid=380191