<This may work
was meant to be a reply to Jim's answer
"Niek Otten" wrote in message
...
This may work, but there is no guarantee that it will calculate the cells
in
the correct order. Also they will be recalculated no matter if that's
necessary or not, which may or may not be a problem from a performance
point of view.
The only correct way is to include all input to the function in the
argument list, just like in "real" math. That's the concept of functions.
Never access precedent cells (or even others) directly from within your
functions.
Kind regards,
Niek Otten
"Phillip Nolan" wrote in message
ups.com...
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?