Edit

Share via


Series.Formula Property

Definition

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

public:
 property System::String ^ Formula { System::String ^ get(); void set(System::String ^ value); };
public string Formula { get; set; }
member this.Formula : string with get, set
Public Property Formula As String

Property Value

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.

Applies to