Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array Maintaining its values after execution
Apologies for starting a new thread, however I could not see a means
of adding to the existing discussion http://groups.google.com/group/micro...&rnum=1&hl=en# Unlike the previous poster I wish to retain the values of my arrays after code execution (in order to repopulate previously captured data on a user form if the user wishes to change their mind after initial submission). Running Excel 2003. However, wherever i declare my array be it globally in a module or ThisWorkbook it always clears itself after code execution. To be honest this is the behaviour I expected and I was surprised with Tom Olgivy's answer that a global variable will retain its value for the life of the workbook. I was expecting to have to add something extra to the declaration. Any help greatly appreciated. Simon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Listing unique values, frequency, and maintaining list order integrity | Excel Worksheet Functions | |||
search an array for values contained in another array | Excel Programming | |||
Maintaining cell 'variable' values even after the the macro has en | Excel Programming | |||
Maintaining VBA variable values | Excel Discussion (Misc queries) | |||
Automatic Macro Execution Upon Cell Values Changing | Excel Programming |