Array Data Not Persistent

[Edd]

Hi:

I have some information on an Excel spreadsheet that I successfully copy to
an Public Array. I use another procedure to extract this same data from the
Public Array but there is no data. How can I maintain data in the array. I've
used the Static keyword but still no luck. What am I missing here. Help
please!

Thanks,

Ed.

[Leith Ross]

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