Difference in finding last row

[alwayslrN]

Can someone explain the difference between these two?

LastRow = Cells(Cells.Rows.Count, "b").End(xlUp).Offset(1).Row

and

LastRow = Cells(Cells.Rows.Count, "b").End(xlUp).Row

Is it where the number of cells in the row with data starts?

Thanks

 

[PHV]

For me, the first expression gives a free row while the second gives the last populated.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[alwayslrN]

As always, PH, thanks for the help.