Why won't this work?

[Djblois]

FinalRow = Cells(Rows.Count, 1).End(xlUp).Row
finalSortRow = FinalRow.Offset(-1, 0).Row

[Bob Phillips]

Because FinalRow is a number, not a range, so you cannot use Offset on it, as this is a range property.

[Djblois]

so I should subtract from it then?

[vonpookie]

Yes.


FinalRow = Cells(Rows.Count, 1).End(xlUp).Row
finalSortRow = FinalRow - 1

[Bob Phillips]

Depends whether you want a row number or a range object.