Custom Functions Auto-Calculate? 3

[IJR]

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

 

[Clyde38]

Inside your function try adding Application.Volatile

 

[joerd]

Your function will only update when the argument values change, unless Application.Volatile is inside your function procedure.
So, [tt]=MyFunction(A1)[/tt] will only update if the value in cell A1 changes, and [tt]=MyFunction()[/tt] will only update if you force recalculation.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.