NamedRange.RefersToR1C1Local Property

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets or sets the formula that the NamedRange control is defined to refer to, using R1C1-style notation in the language of the user.

public:
 property System::String ^ RefersToR1C1Local { System::String ^ get(); void set(System::String ^ value); };

public string RefersToR1C1Local { get; set; }

member this.RefersToR1C1Local : string with get, set

Public Property RefersToR1C1Local As String

Property Value

String

The formula that the NamedRange control is defined to refer to. The formula uses R1C1-style notation in the language of the user, and begins with an equal sign.

Examples

The following code example creates a NamedRange and displays the formula for the NamedRange in the language of the user. It then assigns a new cell to the NamedRange and displays the new formula.

This example is for a document-level customization.

Microsoft.Office.Tools.Excel.NamedRange refersToR1C1LocalRange;
private void DisplayFormulaR1C1Local()
{
    refersToR1C1LocalRange = this.Controls.AddNamedRange(
         this.Range["C1", "D2"], "refersToR1C1LocalRange");
    MessageBox.Show(refersToR1C1LocalRange.RefersTo);
    refersToR1C1LocalRange.RefersTo = "=Sheet1!$C$3";
    refersToR1C1LocalRange.Select();
    MessageBox.Show(refersToR1C1LocalRange.RefersTo);
}

Private refersToR1C1LocalRange As Microsoft.Office.Tools.Excel.NamedRange

Private Sub DisplayFormulaR1C1Local()
    refersToR1C1LocalRange = Me.Controls.AddNamedRange( _
        Me.Range("C1", "D2"), "refersToR1C1LocalRange")
    MessageBox.Show(refersToR1C1LocalRange.RefersTo)
    refersToR1C1LocalRange.RefersTo = "=Sheet1!$C$3"
    refersToR1C1LocalRange.Select()
    MessageBox.Show(refersToR1C1LocalRange.RefersTo)
End Sub

Remarks

Use the RefersToR1C1Local property to change the range that a NamedRange control refers to.

Applies to