Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Custom Functions Auto-Calculate? 3

Status
Not open for further replies.

IJR

Structural
Dec 23, 2000
774
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
 
Replies continue below

Recommended for you

Inside your function try adding Application.Volatile
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor