Can I clear cell contents without changing styling?
You should use the ClearContents method if you want to clear the content but preserve the formatting.
Worksheets("Sheet1").Range("A1:G37").ClearContents
you can use ClearContents. ex,
Range("X").Cells.ClearContents