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:

Please Login or Register  to view this content.

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

Thanks Mumps1. However that clears all contents from the row.
Although useful, because some cells contain formulas, I only want to clear Column C, G, I-P

Mumps1 PERFECT!!!
Many thanks for your help and quick response