Can someone explain to me on this code - Cells(Rows.Count, 1).End(xlUp).Row

[monmon]

Can someone explain to me on this code - Cells(Rows.Count, 1).End(xlUp).Row?

Thanks!

 

[rjwebgraphix]

It's to get the last row of column A.

Cells references the cells
rows.count is the count of all rows used
1 is a reference to column A
.End(xlUp) is like being at a row lower than the last row and pressing CTRL-UpArrow
.Row references the row you stop at after hitting CTRL-UpArrow

Its just an easy way to get the last row of a column.