Series.Formula Property

Returns or sets a String value that represents the object's formula in A1-style notation and in the language of the macro.

Namespace:  Microsoft.Office.Interop.Word
Assembly:  Microsoft.Office.Interop.Word (in Microsoft.Office.Interop.Word.dll)

Syntax

'Declaration
Property Formula As String
    Get
    Set
'Usage
Dim instance As Series
Dim value As String

value = instance.Formula

instance.Formula = value
string Formula { get; set; }

Property Value

Type: System.String
String

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 Formula property returns an empty string. If the object contains a formula, the Formula 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

Reference

Series Interface

Series Members

Microsoft.Office.Interop.Word Namespace