Application Volatile Method

Purpose

This 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.

Syntax

Volatile(Volatile)

Optional Parameters

Volatile

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