Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Findjjing the range that triggered worksheet calculate
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Findjjing the range that triggered worksheet calculate
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Findjjing the range that triggered worksheet calculate
Hi
before inserting the values ypu may add the line application.enableevents = false and after the insertion: application.enableevents = true -- Regards Frank Kabel Frankfurt, Germany Chick wrote: 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Findjjing the range that triggered worksheet calculate
Note that setting enablevents to false will prevent the worksheet calculate
event from being called but if you are in automatic mode the formulae will still be recalculated. regards Charles ______________________ Decision Models FastExcel Version 2 now available. www.DecisionModels.com/FxlV2WhatsNew.htm "Frank Kabel" wrote in message ... Hi before inserting the values ypu may add the line application.enableevents = false and after the insertion: application.enableevents = true -- Regards Frank Kabel Frankfurt, Germany Chick wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Warning text triggered by values of a cell range | Excel Worksheet Functions | |||
Need a triggered formula. | Excel Discussion (Misc queries) | |||
display a range of data when triggered by a specific condition | Excel Worksheet Functions | |||
Formula to retrieve range of dates from a worksheet to calculate d | Excel Worksheet Functions | |||
Combobox Click event triggered when copying worksheet | Excel Programming |