Get row count of last row in sheet using VBA

[mohitkumar966]

Hi All,

I am trying to get the last row count in excel using vba using the below code:

lastrow = Cells(Rows.Count, "A").End(xlUp).Row

but it is not giving me the required result. I am getting 1 as output. even though I checked manually that data is there and Ctrl+Shift+End is also taking me to the last cell of the data.

Thanks in advance.

 

[jproffer]

Works for me. Did you dimension "lastrow" correctly?

This is my code:

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

and I get the correct message...last used row in column A.

I don't think the dimensioning would matter, but maybe.

 

[Rick Rothstein]

Hi All,

I am trying to get the last row count in excel using vba using the below code:

lastrow = Cells(Rows.Count, "A").End(xlUp).Row

but it is not giving me the required result. I am getting 1 as output. even though I checked manually that data is there and Ctrl+Shift+End is also taking me to the last cell of the data.

Do you have data in Column A or does your data start in a different column?

 

[mohitkumar966]

It starts from Column A. I even tried giving the column number instead of name but no luck.

 

[mohitkumar966]

yes, my code matches with your exactly. But still it is not giving me the last row count but 1

 

[Rick Rothstein]

It starts from Column A. I even tried giving the column number instead of name but no luck.

Let me ask the question a different way... is Column A the column with the most data in it?

 

[mohitkumar966]

Yes

Let me ask the question a different way... is Column A the column with the most data in it?

 

[Rick Rothstein]

Yes

Then I can see no reason why the code you posted in Message #1 will not return the correct last row number (by the way, it works for me).

 

[mohitkumar966]

Thanks guys for help. Got the solution. I was actually in different window and hence was not getting the correct answer.
Used window function to switch window and then it is working fine.

 

[mohitkumar966]

Then I can see no reason why the code you posted in Message #1 will not return the correct last row number (by the way, it works for me).

thanks for help rick..actually it was a silly mistake from my end.