Application.volatile

Phil11

New Member
Joined
Jul 8, 2005
Messages
48
Just out of curiosity:

Why is this statement always written at the function level? Isn't it an application-level property (like application.StatusBar for example)? Or is it truly bound only to the Function in which it is located?


To restate, I'd expect to see something like this:

Function foo()
Dim v as boolean
v = Application.volatileState

Application.volatile
MAIN BODY HERE

Application.volatile = v '.......... Reset volatility to its prior state

End Function
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
It must be "A Feature, Not A Bug" :biggrin:
In this case a useful one giving more control.

If it occurred at the application level it would mean that every UDF would recalculate with each change on the sheet.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,451
Messages
5,572,193
Members
412,447
Latest member
immy
Top