Is there a special command in the visual basic to clear global variables if you suddently cancel the modules?

Is there a special command in the visual basic to clear global variables if you cancel the modules while an excel file still running? thank you very much.

Is there a special command in the visual basic to clear global variables if you suddently cancel the modules?
mmmmm!


That is odd, we (The VB programmer) never thought about it.


We consider that breaking the sub while it is running is an error.


So, you will have to face the error and redo it again


I recommand you to do another thing, that is make a function to call before you use that global variable at each usage


This way, you will make sure it is not stopped in the middle of its work





Thanks for this question.





Enjoy my profile, I am the VBAXLMan