Forum Discussion

iqbal1991's avatar
iqbal1991
Copper Contributor
Dec 04, 2019

My excel Mac crashing if I run VBA macro that has looping formula

My file is crashing if I run VBA macro that has looping formula. My excel mac version is the update one version 16.31

 

I try to press esc twice and CTRL+. to stop the VBA macro calculation, however nothing happening, so I need to force quit my excel.

 

When I try the same file in Excel PC, it works perfectly, I can stop the looping with Esc button.

 

I think this issue occurs because Excel for mac take much GPU Resources when run a looping VBA. Appreciate for any suggestion and solution

excel
Excel on Mac
Macros and VBA

1 Reply

Sort By
  • crazyshoots's avatar
    crazyshoots
    Brass Contributor
    Dec 05, 2019

    iqbal1991Hi, I don't have excel mac but that happens on my windows and it's because I have an errant code. Unless you're very confident that the code worked and it did work previously without changes.. otherwise I'd suggest you relook into the code prior to running it. Most likely the looping part could not find a stop point hence it kept running and using up the memory on the system. 

Resources