I need to have a two-dimensional array that can be accessed from all modules.
The trouble is, I will only know how big it needs to be at runtime.
I know I cannot REDIM the array so the alternative is to create a large enough array accommodate for all possibilities.
(Unless someone else can advice me otherwise)
If I do have to go with that option then I need to understand how big can I go?
Is an array Data(300,300) as Double going to be a problem?
The trouble is, I will only know how big it needs to be at runtime.
I know I cannot REDIM the array so the alternative is to create a large enough array accommodate for all possibilities.
(Unless someone else can advice me otherwise)
If I do have to go with that option then I need to understand how big can I go?
Is an array Data(300,300) as Double going to be a problem?