Application.volatile

[Phil11]

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

 

[BrianB]

It must be "A Feature, Not A Bug"
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.