Can I clear cell contents without changing styling?

excel, vba

Solution

You should use the ClearContents method if you want to clear the content but preserve the formatting.

Worksheets("Sheet1").Range("A1:G37").ClearContents

Problem

Is there a way to clear the contents of multiple cells, but without changing the background/font properties of the cells? I am currently using `Range("X").Cells.Clear` but its removing my background color and I would prefer not to have to "repaint" it on each clear.

Original source