AddressOfRange

Returns the address of the specified range.

Usage

@AddrOfRng(<address>, [<Absolute>]) || @AddrOfRng(<StartRow>, <StartColumn>, <EndRow>, <EndColumn>, [<Absolute>])

Argument Name Description
Absolute Optional (default value: 1); See the Excel Address() function for an explanation of the Absolute argument.
Address This would typically be a range name that you want the address of.
EndColumn The column that ends the range.
EndRow The row that ends the range.
StartColumn The column that starts the range.
StartRow The row that starts the range.