Clear contents (maintain formatting) of set column in last row

So I am trying to design a macro that does the following:
1) Copy last row and paste to new row
2) Then clear contents (while maintaining formatting) of Column C, G, I-P of that new row.

I have achieved part 1 by the following code:

Dim Last_Row As Long

Last_Row = Range("A" & Rows.Count).End(xlUp).Offset(1).Row
Range("A7:P7").Copy Range("A" & Last_Row)

However I am struggling with part 2. Hope you can help