runtime error '17' - Can't perform operation

[jmattus]

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

 

[jmattus]

SOLVED - runtime error '17' - Can't perform operation

Not sure why, but I created a new workbook and copied the module to this new book. Then removed the module from the original location. I then saved the workbook. I then copied the module back into the original workbook from the new one and -- viola! It worked.

JM