Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
AutoAttach Property
AutoCorrect Property
AutoExpandListRange Property
AutoFilter Property
AutoFilterMode Property
AutoFormat Property
AutoFormatAsYouTypeReplaceHyperlinks Property
AutoLayout Property
AutoLength Property
AutoLoad Property
AutoMargins Property
AutomaticStyles Property
AutomationSecurity Property
AutoPercentEntry Property
AutoRecover Property
AutoRepublish Property
AutoScaleFont Property
AutoScaling Property
AutoShapeType Property
AutoShowCount Property
AutoShowField Property
AutoShowRange Property
AutoShowType Property
AutoSize Property
AutoSortField Property
AutoSortOrder Property
AutoText Property
AutoUpdate Property
AutoUpdateFrequency Property
AutoUpdateSaveChanges Property
AxisBetweenCategories Property
AxisGroup Property
AxisTitle Property
Expand Minimize

AddressLocal Property [Excel 2003 VBA Language Reference]

Office 2003

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 Required. An expression that returns one of the objects in the Applies To list.

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.

XlReferenceStyle can be one of these XlReferenceStyle constants.
xlA1 default. Use xlA1 to return an A1-style reference
xlR1C1. Use xlR1C1 to return an 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)

Applies to | Range Collection

See Also | Address Property

© 2015 Microsoft