Range.Address (Excel)

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

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

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

Dim strAddress As String
strAddress = ActiveCell.Address

Arguments

Optional arguments

The following arguments are optional

RowAbsolute (Boolean) - True to return the row part of the reference as an absolute reference. The default value is True.

ColumnAbsolute (Boolean) - True to return the column part of the reference as an absolute reference. The default value is True.

ReferenceStyle (XlReferenceStyle) - The reference style. The default value is xlA1.

Possible return values are xlA1 - Default. Use xlA1 to return an A1-style reference, xlR1C1 - Use xlR1C1 to return an R1C1-style reference.

External (Boolean) - True to return an external reference. False to return a local reference. The default value is False.

RelativeTo (Range) - If 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. NOTE: Testing with Excel VBA 7.1 shows that an explicit starting point is not mandatory. There appears to be a default reference of $A$1.