END command that retains values of variables

[tmallin]

VBA programmers,

I have a check for valid user input in my code that will stop the macro execution with the END command if the input is not valid. However, the END command seems to wipe out my array named speedsreb so that when the user next inputs a valid speed, a subscript out of range error occurs.

Please Login or Register  to view this content.

Is there a way to stop macro execution but have VBA retain all arrays and variables that have been defined up to the point of stopping?

thanks

[tmallin]

Nevermind. Found the answer while continuing to search on it.

Use "Exit Sub" instead of "End"