On Fri, 22 Jun 2007 21:07:08 -0500, Dave Peterson
wrote:

I figure that if you're in the VBE making changes to the the UDF (that's what
you meant in your original post, right???), then it's just as easy to force the
calculation while you're there.

But if you look at the different ways to force calculation in Excel's help,
you'll see something like this (taken from xl2003's help):

Press F9 Calculates formulas that have changed since the last calculation, and
formulas dependent on them, in all open workbooks. If a workbook is set for
automatic calculation, you do not need to press F9 for calculation.

Press SHIFT+F9 Calculates formulas that have changed since the last calculation,
and formulas dependent on them, in the active worksheet.

Press CTRL+ALT+F9 Calculates all formulas in all open workbooks, regardless
of whether they have changed since last time or not.

This one did it. Thanks.

Press CTRL+SHIFT+ALT+F9 Rechecks dependent formulas, and then calculates all
formulas in all open workbooks, regardless of whether they have changed since
last time or not.


--