Excel VBA Remove Cell Fill Color

The following line of code removes the fill color of the cell A1:

Range("A1").Interior.Color = xlNone

The following line of code does the same:

Range(Cells(1, 1), Cells(1, 1)).Interior.Color = xlNone

Before:

Excel VBA, Fill Color, Remove Before
After:

Excel VBA, Fill Color, Remove After

See also:

If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website www.software-solutions-online.com

One thought on “Excel VBA Remove Cell Fill Color”

  1. Frediq says:

    thanks

Leave a Reply

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