Please help! formatting last row

This refers to the range C26:

With .Range("C" & .Rows.Count).End(xlUp)

This resizes the range being referred to 1 row tall (same as it already is) and 22 columns wide (across to X):

.resize(1,22)

Dom