Program (VBA) to test 50x60 table

**french_guy** · 05-10-2013, 06:06 AM

Hi
Is there a way to turn off the calculation at the beginning of the macro, and turn it back on at the end?
For the formula, what is exactly the "--"?
And I should replace my current formula by that one and keep the macro, or does it replace the macro?

**french_guy** · 05-10-2013, 07:17 AM

I've just tried with "Calculation" set to manual in the menu Tool > Option > Calculation
Well, it's much faster...It's instantaneous actually. But what is the difference? Because with Calculation on manual, it seems to work the same (but much faster) than when it's set to Automatic Calculation
What do I miss when I have this parameter set on manual?
Thanks

**french_guy** · 05-10-2013, 06:49 PM

OK, so I found out.....My machine loads are not automatically calculated, so I need the calculation set back to Automatic
What i did is to disable automatic calculation at the beginning of the macro, and enable it at the end. And it seems to work perfectly