Partager via

Range.AddressLocal Property

  • Article

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

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

Syntax

'Declaration
ReadOnly Property AddressLocal ( _
    RowAbsolute As Object, _
    ColumnAbsolute As Object, _
    ReferenceStyle As XlReferenceStyle, _
    External As Object, _
    RelativeTo As Object _
) As String
    Get
'Usage
Dim instance As Range
Dim RowAbsolute As Object
Dim ColumnAbsolute As Object
Dim ReferenceStyle As XlReferenceStyle
Dim External As Object
Dim RelativeTo As Object
Dim value As String

value = instance.AddressLocal(RowAbsolute, _
    ColumnAbsolute, ReferenceStyle, _
    External, RelativeTo)

string this[
    Object RowAbsolute,
    Object ColumnAbsolute,
    XlReferenceStyle ReferenceStyle,
    Object External,
    Object RelativeTo
] { get; }

Parameters

  • RowAbsolute
    Type: System.Object

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

  • ColumnAbsolute
    Type: System.Object

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

  • External
    Type: System.Object

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

  • RelativeTo
    Type: System.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

Type: System.String

Remarks

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

See Also

Reference

Range Interface

Range Members

Microsoft.Office.Interop.Excel Namespace