Getting the number of populated rows in a sheet

[hallingh]

Hi all. This is a very easy question, and I've done this before, but I can't remember the exact coding and I'm somehow having trouble finding an example.

How do you get the number of populated rows in a given column? I know it's something like this:

Private Sub FindRows()
Dim RomNum As Long
RowNum = ActiveSheet.xlEndtoUp
MsgBox(RowNum)
 
End Sub

But I can't remember the exact coding. Thanks for the help!

Hank

 

[VoG]

Try

Private Sub FindRows()
Dim RomNum As Long
RowNum = Range("A" & Rows.Count).End(xlUp).Row
MsgBox RowNum
End Sub

 

[JackDanIce]

Do you mean:

Private Sub FindRows()
Dim RomNum As Long
RowNum = ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row
MsgBox(RowNum)
End Sub

 

[Comfy]

http://www.mrexcel.com/forum/showthread.php?t=32797

 

[hallingh]

Perfect. Thanks!

Hank