Search notes:

Excel functions: ROW and COLUMN

row and column return the row and column number of the current cell or referenced address.

option explicit

sub main() ' {

    activeSheet.cells.clearContents

    cells(2, 2).formula = "=row()"       '  2
    cells(3, 2).formula = "=column()"    '  2

    cells(4, 2).formula = "=row(j6)"     '  6
    cells(5, 2).formula = "=column(j6)"  ' 10

end sub ' }

Github repository about-Excel, path: /functions/row-column.bas

Using address() together with row() and column() to create a reference

=address(row() + y, column() + x) is quite useful to create a reference to cell that has a given relative distance from the cell that contains the formula.

Excel functions: ROW and COLUMN

Using address() together with row() and column() to create a reference

See also