Custom Functions Auto-Calculate?
Custom Functions Auto-Calculate?
(OP)
Pals
I use custom functions in a module in every worksheet. I call this function several times in a worksheet.
Strange thing is sometimes the function doesnt update information unless I press F9 or enter
All auto-calculate options in Excel are active
Any way around this.
respects
IJR
I use custom functions in a module in every worksheet. I call this function several times in a worksheet.
Strange thing is sometimes the function doesnt update information unless I press F9 or enter
All auto-calculate options in Excel are active
Any way around this.
respects
IJR





RE: Custom Functions Auto-Calculate?
RE: Custom Functions Auto-Calculate?
So, =MyFunction(A1) will only update if the value in cell A1 changes, and =MyFunction() will only update if you force recalculation.
Cheers,
Joerd
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.