ADDRESS

row_num

Row number used in the cell reference

Any integer greater than 0 or a reference to a cell containing a number

column_num

Column number used in the cell reference.

The first column corresponds to number 1

Any integer greater than 0 or a reference to a cell containing a number

[reference_type]

(optional)

Type of reference to be returned:

•1: Absolute row and column (for example, $A$1).

•2: Absolute row and relative column (for example, A$1).

•3: Relative row and absolute column (for example, $A1).

•4: Relative column and row (for example, A1).

By default, 1

1, 2, 3, 4

[reference_style]

(optional)

Style of reference to be returned:

A1 (TRUE) or R1C1 (FALSE).

By default, TRUE

TRUE or FALSE

[sheet_name]

(optional)

Name of the sheet to which the reference leads.

Text string with the name of the sheet, for example, “Sheet1”