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.