Hallo, as I noticed, variables, which are declared as public, or on the module level are preserved after finishing VBA code execution, and they are kept in memory until workbook is closed, some error occurs etc..
I’m working on project, where it is necessary to keep some values of variables, and use them in next code execution (without closing workbook).
Is it safe to use variables stored in memory from previous code execution, or it’s safer to save values into some range and read them from the range during next code execution?
I need various kinds of variables in the project, user defined classes, collections, etc..
Thanks,
Karel
I’m working on project, where it is necessary to keep some values of variables, and use them in next code execution (without closing workbook).
Is it safe to use variables stored in memory from previous code execution, or it’s safer to save values into some range and read them from the range during next code execution?
I need various kinds of variables in the project, user defined classes, collections, etc..
Thanks,
Karel
