I am using vba in excel 2016 on a mac.
I am making some additions to some code that has worked before.
When I stop the code mid-execution in the editor, or when the code stops due to errors, I stop the code, correct the problems and press the reset button. When I rerun the code, it is obvious that not all variables have been reset.
I have to press the reset button from 6-12 times before all the variables are reset.
Is there another method to reset all variables to the values they should have at the start of the program?
I am making some additions to some code that has worked before.
When I stop the code mid-execution in the editor, or when the code stops due to errors, I stop the code, correct the problems and press the reset button. When I rerun the code, it is obvious that not all variables have been reset.
I have to press the reset button from 6-12 times before all the variables are reset.
Is there another method to reset all variables to the values they should have at the start of the program?