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! |
Jeff,
Declare the array as public at the top of your module: Public Array_Mortality(1 to 5, 1 to 100, 1 to 100) As Double Then fill it using a dedicated macro that does nothing else. Then, until you close the workbook, the array will be available to all the other macros. HTH, Bernie MS Excel MVP "Jeff" wrote in message ... 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! |
All times are GMT +1. The time now is 08:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com