Solved: row count for specific column

[benong]

hi,
i would like to find out the row count for a particular column, how can i do it?
eg.
Column A has 3 rows of data.
Column B has 5 rows of data.
Column C has 9 rows of data.
Column D has 2 rows of data.
Column E has 6 rows of data.

[benong]

i try this code but it always give me the row count of column A

RowCount = Worksheets("Sheet1").Range(columnField & "1").CurrentRegion.Rows.Count

[GTO]

Maybe:

Sub exa()
MsgBox GetCountA("Sheet2", 3)
End Sub

Function GetCountA(SheetName As String, Col As Long) As Long
Dim wks As Worksheet, rng As Range

Set wks = ThisWorkbook.Worksheets(SheetName)
Set rng = wks.Range(wks.Cells(1, Col), wks.Cells(wks.Rows.Count, Col))

GetCountA = Application.CountA(rng)
End Function

[benong]

dear GTO,
many thanks.

[benong]

this works for me :)
Range("A" & Rows.Count).End(xlUp).Row