Studies show that good grammar leads to more promotions and higher salaries. Write with Grammarly

How to Remove Formatting for Range of Cells in Excel VBA?

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").clearformats

This will clear the formatting for all the cells between a1 to a10.