_Application.Volatile method

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)

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.

Show: