Originally Posted by
johnske
1) Range(Rows.Count, "A").
When you use two comma-separated strings inside the range object, both statements on either side of the comma must be a valid range.
Rows.Count returns a number, "A" returns a string, neither of which is a valid range.
2) Cells(Rows.Count, "A") refers to the value (by default) in the cell at the address A65536, it does not refer to either the row or the column separately, similarly, Cells(Rows.Count, "A").End(xlUp) refers to the value in the cell containing the last piece of data in column A - and not the row. So, no, row's not the default...