Application.worksheetfunction.counta(.cells)

 ›  Application.worksheetfunction.counta(.cells)