Is it necessary to pause Macro for Excel to finish Autocalculation

[[email protected]]

Hi,

I am a newbee to VBA. Need your help to clarify below:

I have a large spreadsheet with lot of complex formulas. Auto calculation option is already on. It takes few seconds for excel to update the formulas/values after each entry.

I have created a macro to loop through all entries and copy the result to another sheet.

So, wanted to know if I need to pause the macro for excel to finish auto calculations after each entry or this will be done automatically.

[brynbaker]

Nothing VBA happens during calculate. You can often expedite macro operateiions by setting application.calculation = xlManual, doing stuff that may make the data out of date but does not depend on the result then resetting to application.calculation = xlAutomatic before you end the macro,
Most things in Excel are synchronous - meaning here tha tthey run in turn. Excel queries by default run in the background but you can disable that to make VBA wait before continiung.

[[email protected]]

Hi, Thanks for your reply!

I dont want the VBA to happen during calculation.

Just want to make sure that the final result that I copy to another sheet with the help of macro, should only be AFTER excel finished the autocalculation.
Macro should not copy the result cells before/in between the excel auto calculation in process.

[brynbaker]

I'm sorry I was not clear; VBA waits (as you must) during every calculation. That is what you want to know.

The other information was to explain that you suspend calculation until it is essential then run it, while vba waits, in may cases.

[[email protected]]

Great...Thanks for your help!