address

Cell address as a text string.

Syntax

v = address(row_num, column_num, abs_num, A1, sheet_text)

Description

Returns a cell-address string like '$A$1'. abs_num: 1 (absolute row/col), 2 (abs row, rel col), 3 (rel row, abs col), 4 (relative). A1: true (A1 notation, default) or false (R1C1). sheet_text: optional sheet name to prepend.

Examples

address(2, 3)            % '$C$2'
address(2, 3, 4)         % 'C2'
address(2, 3, 1, true, 'Data')   % 'Data!$C$2'

See also

• indirect — Reference resolved from a text string.
• row — Row number of a reference.
• column — Column number of a reference.