Expand Minimize

Range.AddressLocal Property (Excel)

Returns the range reference for the specified range in the language of the user. Read-only String.

expression .AddressLocal(RowAbsolute, ColumnAbsolute, ReferenceStyle, External, RelativeTo)

expression A variable that represents a Range object.

Parameters

Name

Required/Optional

Data Type

Description

RowAbsolute

Optional

Variant

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

ColumnAbsolute

Optional

Variant

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

ReferenceStyle

Optional

XlReferenceStyle

One of the constants for XlReferenceStyle specifying A1-style or R1C1-style reference.

External

Optional

Variant

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

RelativeTo

Optional

Variant

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.

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

Assume that this example was created using U.S. English language support and was then run in using German language support. The example displays the text shown in the comments.

Set mc = Worksheets(1).Cells(1, 1) 
MsgBox mc.AddressLocal() ' $A$1 
MsgBox mc.AddressLocal(RowAbsolute:=False) ' $A1 
MsgBox mc.AddressLocal(ReferenceStyle:=xlR1C1) ' Z1S1 
MsgBox mc.AddressLocal(ReferenceStyle:=xlR1C1, _ 
 RowAbsolute:=False, _ 
 ColumnAbsolute:=False, _ 
 RelativeTo:=Worksheets(1).Cells(3, 3)) ' Z(-2)S(-2)

Concepts

Other resources

Show:
© 2014 Microsoft