"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.

Thank you
If I have understood correctly I just create a class module with the array
declared as public?
If so how do I run the procedure and transfer the data from the standard
module to the class module array?
I am grateful for the cooperation