There is no general way of finding out which formulae or events have
triggered a recalculation.
If you want to stop the recalculation then either
- switch calculation to manual
- make sure that no formulae refer to the cells you are populating
regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm
"Chick" wrote in message
om...
I am using Excel 97.
I use VBA to populate 2 cells with values.
When these cells are populated two adjacent cells containing formulas
trigger the worksheet calculate event. I do not want this to happen.
I have tried using application.caller..
Select Case TypeName(Application.Caller)
Case "Range"
v = Application.Caller.Address
Case "String"
v = Application.Caller
Case "Error"
v = "Error"
Case Else
v = "unknown"
End Select
MsgBox "caller = " & v
But it always returns "Error"
Is there another way to find out what is triggering the worksheet
calculate?