_Application.Volatile(Object) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Marks a user-defined function as volatile. A volatile function must be recalculated whenever calculation occurs in any cells on the worksheet. A nonvolatile function is recalculated only when the input variables change. This method has no effect if it's not inside a user-defined function used to calculate a worksheet cell.
public void Volatile (object Volatile);Public Sub Volatile (Optional Volatile As Object)Parameters
- Volatile
- Object
Optional Object. True to mark the function as volatile. False to mark the function as nonvolatile. The default value is True.