SETF Function

Sets a cell's formula.

Syntax

SETF( GETREF(cell ), formula )

Parameters

Name	Required/Optional	Data Type	Description
cell	Required	String	The cell whose formula to set.
formula	Required	String	The formula to use.

Remarks

When evaluated, the result of the expression in formula becomes the new formula in cell. If formula is enclosed in quotation marks, the quoted expression is written to cell. To set cell to a string, enclose formula in three sets of quotation marks.

The target cell must be specified using a GETREF() reference or as a string to avoid circularity. Using GETREF is preferred, because Microsoft Visio can adjust references when the shape is moved to a different document.

If cell is not specified using GETREF or as a string, the function returns an error, and no cell's formula is changed. If formula contains a syntax error, the function returns an error, and the formula in cell is not changed.

Example 1

SETF( GETREF(Scratch.A1), 1.5 in * 6 + 1 ft)

Sets the formula of Scratch.A1 to 21 inches.

Example 2

SETF( GETREF(Scratch.A1), "1.5 in * 6 + 1 ft")

Sets the formula of Scratch. A1 to the expression 1.5 in*6+1 ft.

Example 3

SETF( GETREF(Scratch.A1), """Say """"ahh""""""")

Sets the formula of Scratch.A1 to the string "Say ""ahh""" which evaluates to Say "ahh".