SetWatch
Sends the values of a specified range of cells to the DataChannel when the spreadsheet is updated. For more information, see DataChannel Communications.
Note: The SetWatch
function does not appear in the list of functions within the Insert
Function dialog; it must be typed in manually.
Inputs
Syntax: SetWatch(Upper-Left-Cell,Lower-Right-Cell,Mode)
Parameter | Description | ||||||
---|---|---|---|---|---|---|---|
Upper-Left-Cell |
Specifies upper left-most cell within the range of cells. |
||||||
Lower-Right-Cell |
Specifies lower right-most cell within the range of cells. |
||||||
Mode |
Specifies when data is sent to the DataChannel after the spreadsheet is updated.
|
Outputs
Returns the value of the selected Mode.