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.

0 = disable	Disable the function.
1 = if changed	Send data only when the spreadsheet has been modified.
2 = always	Always send data.

Outputs

Returns the value of the selected Mode.