VBA Array
I have code that takes five 100x100 matrix's and put them in the array
Array_Mortality(5,100,100)
The information comes from a spreadsheet = Mortality, the spreadsheet has
five tabs.
The code is in another spreadsheet that uses the array - with a bunch of
other code.
Question = usually I run a macro that uses Array_Mortality, then I might do
some other stuff and then run the macro again. It is a pain to keep opening
up the other file. Is there any way to permanently save the array, so I
don't have to keep on opening the other file, because this slows things down
a lot.
Thanks!
|