I am running some code that has worked for months. I added a short while loop. This worked great. I then put an on error goto label line and include the label identifier. This worked great.
In stepping through the code, I changed the goto statement and the actual label itself. When I did this, Excel told me that the code would need to be reset. I clicked ok. I then saved my work and tried to run the code again. Now it won't get passed compiling the vba project. In MS's help, it says "An operation can't be carried out if it would invalidate the current state of the project. . . To make such changes, you must stop the module from running, make the additions or changes, and then restart execution. " I can't get this to work. Anyone have any suggestions?
JM
In stepping through the code, I changed the goto statement and the actual label itself. When I did this, Excel told me that the code would need to be reset. I clicked ok. I then saved my work and tried to run the code again. Now it won't get passed compiling the vba project. In MS's help, it says "An operation can't be carried out if it would invalidate the current state of the project. . . To make such changes, you must stop the module from running, make the additions or changes, and then restart execution. " I can't get this to work. Anyone have any suggestions?
JM