Excel VBA

Hi Beyers

Thank you for your question

Removing all the formatting involves manipulating multiple propeties of different objects (Font, Interior etc.). The quickest way would be to use a with structure.

For example

With RangeObject

.interior.colorindex = xlNone
.font.italic = false
.font.bold = false

End with

Regards

Stephen