Stepping Through (F8) Code suddenly executes all code?

user_1540019 0
Viewed 18856

A Macro that I wrote (on another machine) is suddenly acting strange on my computer. I wrote the code in the Excel 2010 environment and am trying to step through the code in the same.

Everytime I do so, after a few lines, the rest of the code is immediately executed. If I set a breakpoint it will stop. Sometimes, I can then step through a few more lines before it just auotexecutes again.

What gives? I have found no answers on the web... thus my first post on Stackoverflow.

Thanks for any hints! This is making my life difficult.

UPDATE: I have now gone back to the original programming environment and the stepping through the code there is no problem. So it must be something in my Excel settings! I can't figure out what it could possible be though.

vba excel
9 Answers

I know this is a very old thread, but I just found it. I check the task manager and found that I had a "stuck" Access process running. I got rid of that and everything works find now.

user_84729010

I faced the same issue. I created a new module and pasted my code into this new module and it Worked!! Hope it helps if someone is facing the same issue.

user_89317170

Registry related solution says, QWORD should be used in a 64-64 combo. Tried, didn't work, so I went for DWORD, which instantly solved it. Just in case, some gets stuck the same way...

Thanks for the solution! :)

user_197178690
Related