Programming Excel with VBA and .NET

Name

range.Address([RowAbsolute], [ColumnAbsolute], [ReferenceStyle], [External], [RelativeTo])

Returns the range reference for the specified range.

Argument	Settings
`RowAbsolute`	True (default) returns the row reference as an absolute reference.
`ColumnAbsolute`	True (default) returns the column reference as an absolute reference.
`ReferenceStyle`	`xlA1` (default) returns an A1-style reference. Use `xlR1C1` to return an R1C1 reference.
`External`	False (default) returns a local reference, without including a workbook and worksheet reference.
`RelativeTo`	The `Range` object that defines the starting point for a relative range. Use this argument if `RowAbsolute` and `ColumnAbsolute` are False, and `ReferenceStyle` is R1C1.

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.