VBA for last Row...

[Matty]

Hi,

Historically, I have always used:

LR = Range("B" & Rows.Count).End(xlUp).Row

to establish the last Row in a Column. However, I have noticed today that if the last few Rows of data are hidden, the above only reflects the last unhidden Row.

Is there a reason for this behaviour?

Thanks,

Matty

 

[Jonmo1]

The xlUp mimicks the action of pressing CTRL + UP on your keyboard.
And that is what happens when you do that.

 

[Matty]

Hi jonmo1,

That makes sense. Is there an alternative way that includes hidden Rows?

Thanks,

Matty

 

[Jonmo1]

Try

LR = Range("B:B").Find("*", , , , , xlPrevious).Row

 

[Matty]

Thanks jonmo1.

Matty