Hello Chris,

The destination range is assumed to have a header in row 1. The UsedRange will start at this row. Since it is the lowest row number, there is no need to check further. The Offset(1, 0) always starts the data in row 2. The UsedRange includes all entries on the worksheet as well as formatting like borders and cell background colors. Everything except row 1 is cleared.