How to get the row count in EXCEL VBA

Question

I am developing a dashboard in excel. And I am looking for calculating row count. (How many records are present) .. Since there are some blank cells I thought to go from bottom to up. I use the following ``` Range("A1048576").Select Selection.End(xlUp).Select ``` After this execution the active cell is at A113 which means the row count is 113. My question is how to get this number 113 from the active cell?

Accepted Answer

You can use this:

```
Dim lastrow as Long
lastrow = Cells(Rows.Count,"A").End(xlUp).Row
```

`lastrow` will contain number of last empty row in column `A`, in your case 113

How to get the row count in EXCEL VBA

Solution

Problem