You can use the ROW function and COLUMN function to find row and column numbers on a worksheet. Notice both ROW and COLUMN return values for the current cell if no reference is supplied:
ROWS and COLUMNS
The ROWS function and COLUMNS function provide a count of rows in a
reference.