Option Explicit

Function recal()
Debug.Print "recalculating"
recal = "done"
End Function

Sub dosth()
Range("a1").Calculate
End Sub

I input in the a1 cell with "=recal()" and run sub dosht() for
serveral times. In immediate window, I didn't see "recalculating"
printed.

Why? Range("a1").Calculate won't force the reevaluation of a1 cell?

See http://www.decisionmodels.com/calcsecretsg.htm etc for explanation

Charles
___________________________________
London Excel Users Conference April 1-2
The Excel Calculation Site
http://www.decisionmodels.com

"Xiaozhong" wrote in message
...
Option Explicit

Function recal()
Debug.Print "recalculating"
recal = "done"
End Function

Sub dosth()
Range("a1").Calculate
End Sub

I input in the a1 cell with "=recal()" and run sub dosht() for
serveral times. In immediate window, I didn't see "recalculating"
printed.

Why? Range("a1").Calculate won't force the reevaluation of a1 cell?