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