Hello Edd,

There are 3 points that could be the cause of the problem. First, the
Array must be delared Public in the delclarations section of Standard
VBA Module to be accessable to the rest of the program. Second, the
Array data will persist only as long as the VBA code is running. Third,
make sure the Array is not being cleared elsewhere in the code.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=513767