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.
See also this link.

See also

Excel functions

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/Microsof...', 1758201038, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/Microsoft/Office/Excel/functions/row-column(61): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78