best way to select the last row in a sheet

[ammartino44]

Hello. I saw this code

LastRow = ActiveSheet.UsedRange.Rows.Count

as a way to get to the last active row. However, I've seen it done another more common way, but I forget the code. Which way is best?

[zbor]

Use this:

LastRow = Range("A65536").End(xlUp).Row

[ammartino44]

But what's the difference?

[stnkynts]

Just a couple of points to note:

UsedRange.Rows.Count will get you the lastrow used row for the whole worksheet. This may not be what you want (e.g. Maybe you have subtotal rows you don't want to include). While zbor's way will be column specific. Another iteration of UsedRange.Rows.Count is the use of specialcells. ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastCell).Row.

One more point. Specifying a numerical row using zbor's example could be problematic depending on the version of excel. Generally, this is more acceptable:

lastrow = Range("A" & Rows.Count).End(xlUp).Row