It could be a public variable in a General module.
It could be a static variable in a general module.



Joel wrote:

the only way VBA saves code between execution is using class modules or
userform (which is a class module). Create a class module or userform with
only the array delcared in the module as public. The array doesn't even have
to be in a subroutine or function. Then from your main routine create a new
version of the class module to create the array.

"piero" wrote:

Hello everyone,
I have a small problem: I would like to store an array in VB Excel 2007
(without using a sheet for caching).
You know tell me what instructions can I use so that when strengthened from
the application and return concourse data stored?
There sending code and thank you.

--

Dave Peterson