Thread: VBA Array
View Single Post
  #1   Report Post  
Jeff
 
Posts: n/a
Default 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!