In this post, you’ll learn how you can use ClearFormats property to remove formatting for all cells or range of cells programmatically in your Excel spreadsheet using Excel VBA.
How to Remove Formatting for Range of Cells in Excel VBA?
You can clear the formatting for range of cells by using the range object and calling the clearformats property as shown below.
Range("a1:a10").clearformatsThis will clear the formatting for all the cells between a1 to a10.
