If you want the count of rows and cells to appear in a cell that is the lower
right corner cell on a worksheet, use this formula in that cell.
="Rows: " & ROW() & " Cells: " & ROW()*COLUMN()
For example, if you put that formula in cell E9, it will display:
Rows: 9 Cells: 45