On Aug 30, 3:06*pm, "kittronald" wrote:
* * Does Excel provide a way to detect when a selection of formulas have
completed calculation or when a file save has completed ?

* * I want to run a macro, save the file, run another macro and save the
file again.

* * However, before each save, all formulas must have completed calculation.

* * Is this possible ?

- Ronald K.

sub runandsave()
macro1
activeworkbook.save
macro2
activeworkbook.save
end sub