# of rows given column

[Tejas Kokje]

Hi,
I am very newbie to excel programming. I wanted to know how can i get
the number of rows of a particular column.

Regards,
Tejas Kokje

 

[Ken Wright]

There are 65,536 rows (cells) in every column - You may need to clarify your
question - Are you perhaps looking for the number of non blank rows in a column,
the number of rows with numbers in, numbers and text, or perhaps just the last
row that has data in. Does the data have blanks etc - The more data you can
give us, the easier it is to give you a proper reply

 

[Frank Kabel]

Hi
if you want to get the last used row try
sub foo()
dim lastrow as long
LastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).row
msgbox "Last used row in column A is: " & lastrow
end sub

 

[mudraker]

To Get total number of rows in Excel sheet
RowCount = Rows.Count


To get last used row number for entries in column A

RowNumber = Cells(Rows.Count, "a").End(xlUp).Row

Add 1 to give next blank cell

RowNumber = Cells(Rows.Count, "a").End(xlUp).Row +