On Fri, 22 Jun 2007 20:17:58 -0500, Dave Peterson
wrote:

You could always create another macro that recalculates everything

or even just show the immediate window in the VBE (ctrl-g).

Then type this and hit enter:
application.calculatefull

That did it. Now how come that works, but clicking the Calculate Now
icon (Excel 2007) doesn't?

I don't want to always be opening up the IDE to enter that in the
Immediate window.

I suppose I could write a recalculate macro, as you suggest, but isn't
thay what Calculate Now is supposed to do?

There are different levels of recalculating. Look in VBA's help for more info.
(And some have been added since xl97.)

LurfysMa wrote:

I have a worksheet that calls some custom macros.

When I change the macro, the cells don't recalculate.

How can I tell Excel to recalculate all of the cells in the worksheet?

--


--