excel vba last row variable not computing

Question

I am using the lines:

Dim lastrowmonth as Integer, PMARow As Integer
lastRowMonth = Cells(1 & "," & Rows.Count).End(xlUp).Row
Do While PMARow < lastRowMonth + 1

However it keeps telling me that lastRowMonth = 1and as such wont let me access my code, inside the do while. Any advice here as there are 1400 filled cells in column A and ideally I want to move on to changing 1 to a variable to move through other columns.

Any help would be grand!

If you're using Cells, it is Cells(row, column) not the opposite. — simpLE MAn
– simpLE MAn, Commented Feb 13, 2014 at 3:07

simpLE MAn · Accepted Answer · 2014-02-13 03:05:00Z

2

Try this:

lastRowMonth = Cells(Rows.Count,1).End(xlUp).Row

And maybe it would be a good idea to declare lastRowMonth as a Long to be sure because in excel there are more rows than an Integer can take

answered Feb 13, 2014 at 3:05

simpLE MAn

1,62214 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

simpLE MAn Over a year ago

No problem @CJones. And, I don't know you but I'm pretty sure you're not an idiot :)

Netloh · Accepted Answer · 2014-02-13 03:04:39Z

2

You need to change the second line to:

lastRowMonth = Cells(Rows.Count, 1).End(xlUp).Row

answered Feb 13, 2014 at 3:04

Netloh

4,3784 gold badges27 silver badges38 bronze badges

Collectives™ on Stack Overflow

excel vba last row variable not computing

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related