Using Sheet1.Cells.ClearContents will preserve your formatting.

Regards

Per

"Gus Chuch" skrev i en meddelelse
...
How can I reset my format cell properties back after I do a
Sheet1.Cells.Clear?
I have each cell with a border outline and some cells I merge together. I
think I have to use the range object but I'm not to sure how to do it.

--
thank You
gus chuchanis