Series.Formula Property (Word)

Returns or sets the object's formula in A1-style notation and in the language of the macro. Read/write String.

Version Information

Version Added: Word 2007

Syntax

expression .Formula

expression A variable that represents a Series object.

Remarks

This property is not available for OLAP data sources.

If the object contains a constant, this property returns the constant. If the object is empty, this property returns an empty string. If the object contains a formula, this property returns the formula as a string in the same format that would be displayed in the formula bar (including the equal sign).

If the range is a one- or two-dimensional range, you can set the formula to a Visual Basic array of the same dimensions. Similarly, you can put the formula into a Visual Basic array.

See Also

Concepts

Series Object

Series Object Members