Export (0) Print
Expand All
Expand Minimize

Range.Address Property

Office 2007
Returns a String value that represents the range reference in the language of the macro.


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

expression   A variable that represents a Range object.


NameRequired/OptionalData TypeDescription
RowAbsoluteOptionalVariantTrue to return the row part of the reference as an absolute reference. The default value is True.
ColumnAbsoluteOptionalVariantTrue to return the column part of the reference as an absolute reference. The default value is True.
ReferenceStyleOptionalXlReferenceStyleThe reference style. The default value is xlA1.
ExternalOptionalVariantTrue to return an external reference. False to return a local reference. The default value is False.
RelativeToOptionalVariantIf RowAbsolute and ColumnAbsolute are False, and ReferenceStyle is xlR1C1, you must include a starting point for the relative reference. This argument is a Range object that defines the starting point.


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


The following example displays four different representations of the same cell address on Sheet1. The comments in the example are the addresses that will be displayed in the message boxes.

Visual Basic for Applications
Set mc = Worksheets("Sheet1").Cells(1, 1)
MsgBox mc.Address()                              ' $A$1
MsgBox mc.Address(RowAbsolute:=False)            ' $A1
MsgBox mc.Address(ReferenceStyle:=xlR1C1)        ' R1C1
MsgBox mc.Address(ReferenceStyle:=xlR1C1, _
    RowAbsolute:=False,     _
    ColumnAbsolute:=False,  _
    RelativeTo:=Worksheets(1).Cells(3, 3))        ' R[-2]C[-2]

Community Additions

© 2014 Microsoft