Code works fine when stepping through code but Excel freezes if I run it without stepping

[OldManExcellor]

The following macro Main_FinExport runs fine when I start the procedure of with Stop and then step through the code with Shift+F8. But when I just run it, Excel crashes every time. Any ideas for how I can fix this?

Please Login or Register  to view this content.

[LJMetzger]

Hi OldManExcellor,

Your symptoms sound like a problem caused by an endless loop that occurs when Excel Events are NOT disabled. That is probably why the code works when you Single Step.

Try:

Please Login or Register  to view this content.

Lewis

[OldManExcellor]

To the best of my knowledge I have no macro in the file that triggers on event change. But your solution seems to work. The macro hasn't caused Excel to freeze all day. I had a lot of headache because of this. Thank you a lot Lewis!

[LJMetzger]

To the best of my knowledge I have no macro in the file that triggers on event change.

Your welcome. It does not have to be a macro. If you have formulas that change, you could be triggering a Worksheet_Calculate() event each time a formula is affected, which may cascade and cause a lot of calculations.