Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to force a recalculation of values based on custom function
Hi,
I've written a custom function (Calculate_Budget_By_Quarter) that conditionally sums values from one worksheet by iterating through all rows on that worksheet. The function is then called in multiple cells in another worksheet (=Calculate_Budget_By_Quarter (Arg1, Arg2)). In spite of putting .Calculate for these cells in the Activate event of the sheet where the custom function is used, nothing happens when I add/change/remove rows on the first worksheet. Any ideas how I might fix this? Cheers, W PS: Thanks Tom and Chrissy for your help with getting the function to work in the first place :-) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to force a recalculation of values based on custom function
If you are using xl2000 or later, use CalculateFull
-- Regards, Tom Ogilvy "Wim Bartsoen" wrote in message ... Hi, I've written a custom function (Calculate_Budget_By_Quarter) that conditionally sums values from one worksheet by iterating through all rows on that worksheet. The function is then called in multiple cells in another worksheet (=Calculate_Budget_By_Quarter (Arg1, Arg2)). In spite of putting .Calculate for these cells in the Activate event of the sheet where the custom function is used, nothing happens when I add/change/remove rows on the first worksheet. Any ideas how I might fix this? Cheers, W PS: Thanks Tom and Chrissy for your help with getting the function to work in the first place :-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to force the use of a specific custom list in a excel 2007 cha | Excel Worksheet Functions | |||
Force Selection of Custom Views | Excel Discussion (Misc queries) | |||
Custom formatting to force a decimal place | Excel Discussion (Misc queries) | |||
Force refresh of custom functions | Excel Worksheet Functions | |||
Force Recalculation | Excel Discussion (Misc queries) |