The following line of code removes the fill color of the range A1:B2:

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


The following line of code does the same:

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


Before:

After:

See also:

• Excel VBA, Cell Fill Color
• Excel VBA, Formatting Cells and Ranges using the Macro Recorder

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