Use VBA Remove Duplicates without removing cell formatting

Hey,

I have a some code which will output a table depending on the users choices in an initial menu. I then use:

Sheets(results).Range("C8:I108").RemoveDuplicates Columns:=Array(1, 2), Header:=xlYes

to remove any duplicates in the final table but it is also removing the formatting of the cells which means when the program is run again - if the new results table is longer than the last, the last few rows don't match the formatting that was set in the sheet.

Please help.

Thanks