_Application.Volatile Method

  • Article

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.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub Volatile ( _
    Volatile As Object _
)
'Usage
Dim instance As _Application
Dim Volatile As Object

instance.Volatile(Volatile)

void Volatile(
    Object Volatile
)

Parameters

  • Volatile
    Type: System.Object

    Optional Object. True to mark the function as volatile. False to mark the function as nonvolatile. The default value is True.

See Also

Reference

_Application Interface

_Application Members

Microsoft.Office.Interop.Excel Namespace