Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng 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
Joined
Dec 23, 2000
Messages
774
Location
TR
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
 
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

Back
Top