Edit

Share via


Range.AddressLocal[Object, Object, XlReferenceStyle, Object, Object] Property

Definition

Returns the range reference for the specified range in the language of the user.

public:
 property System::String ^ AddressLocal[System::Object ^, System::Object ^, Microsoft::Office::Interop::Excel::XlReferenceStyle, System::Object ^, System::Object ^] { System::String ^ get(System::Object ^ RowAbsolute, System::Object ^ ColumnAbsolute, Microsoft::Office::Interop::Excel::XlReferenceStyle ReferenceStyle, System::Object ^ External, System::Object ^ RelativeTo); };
public string AddressLocal[object RowAbsolute, object ColumnAbsolute, Microsoft.Office.Interop.Excel.XlReferenceStyle ReferenceStyle = Microsoft.Office.Interop.Excel.XlReferenceStyle.xlA1, object External, object RelativeTo] { get; }
Public ReadOnly Property AddressLocal(Optional RowAbsolute As Object, Optional ColumnAbsolute As Object, Optional ReferenceStyle As XlReferenceStyle = Microsoft.Office.Interop.Excel.XlReferenceStyle.xlA1, Optional External As Object, Optional RelativeTo As Object) As String

Parameters

RowAbsolute
Object

Optional Object. True to return the row part of the reference as an absolute reference. The default value is True.

ColumnAbsolute
Object

Optional Object. True to return the column part of the reference as an absolute reference. The default value is True.

ReferenceStyle
XlReferenceStyle

Optional XlReferenceStyle.

External
Object

Optional Object. True to return an external reference. False to return a local reference. The default value is False.

RelativeTo
Object

Optional Object. If RowAbsolute and ColumnAbsolute are both set to False and ReferenceStyle is set to xlR1C1, you must include a starting point for the relative reference. This argument is a Range object that defines the starting point for the reference.

Property Value

Remarks

If the reference contains more than one cell, RowAbsolute and ColumnAbsolute apply to all rows and all columns, respectively.

Applies to