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.
Last edited by OldManExcellor; 01-15-2016 at 09:11 AM.
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:
LewisPlease Login or Register to view this content.
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!
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.To the best of my knowledge I have no macro in the file that triggers on event change.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks