Hi Bura,

Ctrl-alt-F9 recalculates every formula in all open workbooks

re-entering a formula causes just that formula to be evaluated (and if
calculation is automatic then all volatile and dependent formulae will also
be recalculated)

vba for recalculating the activecell is
activecell.calculate

or activecell.formula=activecell.formula

(or you could replace the = in the formula with =)


see also my "calculating from VBA" page
http://www.decisionmodels.com/calcsecretsh.htm

Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

"Bura Tino" wrote in message
...
Hi,

Consider a cell with some formula in it. From excel's point of view, what
is
the difference between my pressing Ctrl-Alt-F9 for a recalc and actually
clicking into the cell and pressing Enter? What's the VBA for the latter?

Thanks,

Bura