3.7.5.103.41 wks.col.setformula

setformula

Syntax

wks.col.setformula([string register], autoupdatemethod = au_none)

Description

Set column formula. The first argument is mandatory and contains the name of the system string containing the column formula (in the example below it is Z). The second argument is optional and takes values from the enumeration AUTOUPDATEMODE (default = AU_NONE) to specify the autoupdate mode.

Examples

%Z = "col(1) + 100"; 
wks.col2.SetFormula(Z, 1);

See also

wks.col.formula$, wks.col.svrm