As far as I have seen, Excel VBA Help is not especially helpful on the topic of the various “calculate” methods that are available. To make matters worse, sometimes the “calculate” buttons in the user interface don’t seem to work, leading me not to trust the lesser calculate methods and tending to go for the more extensive methods such as Application.CalculateFull and Application.CalculateFullRebuild. My question concerns the circumstances in which one should choose the various calculate methods, as well as the broader issue of whether or not to choose manual calculation mode. I should remark that for spreadsheets that are largely driven by spreadsheet functions (as distinct from being largely driven by VBA code), I make heavy use of the INDIRECT function.

I hope that Rev Dodgson gets to see this question.

mollwollfumble said:

I hope that Rev Dodgson gets to see this question.

I did see it, but didn’t respond because I don’t really have a lot to add.

I almost always have spreadsheets set to Auto reclac. If things get too slow I move the slow calculations to a macro.

Many of my user-defined functions are non-volatile, which means that you need to change the value of one of the argument functions to get it to recalc.

I almost never use the recalc icons. I use F9 for recalc (when in manual mode) or Ctrl-Alt-F9 to recalc everything.