Application.worksheetfunction.counta(columns(1))

 ›  Application.worksheetfunction.counta(columns(1))