Hi Tushar,

Even then, if (some of) the input cells weren't in the argument list, there
is no guarantee that the formulas will be calculated in the correct order
and will remain to do so in future versions of Excel; this is not part of
Excel's specifications.

--
Kind regards,

Niek Otten

"Tushar Mehta" wrote in message
om...

Just use CTRL+SHIFT+ALT+F9 which is the keyboard shortcut for "Force
recalculate everything in sight and then some more." {grin}

No need for something as volatile as Application.Volatile.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article . com,
says...
I can define a Visual Basic function (via Tools - Macro - Visual
Basic Editor) and the function is indeed called for all cells
referencing it the first time that I select "Close and Return to
Microsoft Excel."

The problem is that when I re-edit the same function and "Close and
Return to Microsoft Excel" the cells are not updated automatically.

How can I get Excel to refresh my entire page automatically upon saving
my VB function and returning to Excel?