NamedRange.RefersToLocal 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 A1-style notation in the language of the user.

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

public string RefersToLocal { get; set; }

member this.RefersToLocal : string with get, set

Public Property RefersToLocal As String

Property Value

String

The formula that the NamedRange control is defined to refer to. The formula uses A1-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 refersToLocalRange;
private void DisplayFormulaLocal()
{
    refersToLocalRange = this.Controls.AddNamedRange(
         this.Range["C1", "D2"], "refersToLocalRange");
    MessageBox.Show(refersToLocalRange.RefersTo);
    refersToLocalRange.RefersTo = "=Sheet1!$C$3";
    refersToLocalRange.Select();
    MessageBox.Show(refersToLocalRange.RefersTo);
}

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

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

Remarks

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

Applies to