Hi
A sample VBA code below may be help you.
Sub countRows()
Dim lngRowsProject As Long
lngRowsProject = Columns("AG:AG").SpecialCells(xlVisible).Rows.Count
lngRowsProject = Range("AG").CurrentRegion.Rows.Count
MsgBox "The number of rows is " & lngRowsProject
End Sub