VBA: How to Remove Cell Fill Colors


You can use the following basic syntax in VBA to remove borders from cells in a specific range:

Sub RemoveFillColor()
Range("A1:B12").Interior.Color = xlNone
End Sub

This particular example removes all fill colors from the cells in the range A1:B12.

The following example shows how to use this syntax in practice.

Example: Using VBA to Remove Cell Fill Colors

Suppose we have the following dataset in Excel that contains information about various basketball players:

Suppose we would like to remove the fill colors from each cell in the range A1:B12.

We can create the following macro to do so:

Sub RemoveFillColor()
Range("A1:B12").Interior.Color = xlNone
End Sub

When we run this macro, we receive the following output:

Notice that the fill colors in each cell in the range A1:B12 have been removed.

To remove the fill colors from cells in a different range, simply change A1:B12 to a different range within the macro.

Note: You can find the complete documentation for the VBA Interior.Color property here.

Additional Resources

The following tutorials explain how to perform other common tasks using VBA:

VBA: How to Remove Borders from Cells
VBA: How to Count Number of Sheets in Workbook
VBA: How to Count Number of Rows in Range

Leave a Reply

Your email address will not be published. Required fields are marked *