How about just changing = to =

Excel will see that as a change to the formula and reevaluate (calc mode is
automatic, right?).

Jim Luedke wrote:

Niek and Stefi:

(Very!) belated thanks for your reply to my Q about how to force
recalc of UDFs.

Application.Volatile does not seem to work.

Nor does Application.CalculateFull.

Nor does Worksheet.Calculate.

Nor does Cell.Calculate on the desired cell(s).

Nor does a great suggestion by a Michael Rickards in a 1995 entry in
comp.apps.spreadsheets:

SaveFormula = Cell.Formula
Cell.Clear
Cell.Formula = SaveFormula

Somewhat unbelievably, the above merely re-enters the obsolete, un-
recalc'ed value into the cell.

I just cannot seem to, simply, force update of (all?) cells containing
(all?) UDF(s) at VBA runtime.

Anyone else?

Thanks much again.

***

--

Dave Peterson