Jump To:

• Remove Fill Pattern From Cell
• Remove Fill Pattern From Range
• Remove Fill Pattern From Column
• Remove Fill Pattern From Row
• Remove All Fill Pattern From Sheet

Remove Fill Pattern From Cell:

The following line of code removes the fill pattern from cell B2:

Range(Cells(2, 2), Cells(2, 2)).Interior.Pattern = xlNone


The line below is also equivalant to the previous line:

Range("B2").Interior.Pattern = xlNone


Before:

After:

Remove Fill Pattern From Range:

The following line of code removes the fill pattern from the range “B2:D2”:

Range(Cells(2, 1), Cells(2, 4)).Interior.Pattern = xlNone


The line below is also equivalant to the previous line:

Range("B2:D2").Interior.Pattern = xlNone


Before:

After:

Remove Fill Pattern From Column:

The following line of code removes the fill pattern from column C:

Columns(3).Interior.Pattern = xlNone


Before:

After:

Remove Fill Pattern From Row:

The following line of code removes the fill pattern from row 2:

Rows(2).Interior.Pattern = xlNone


Before:

After:

Remove All Fill Pattern From Sheet:

The following line of code removes all fill patterns from sheet1:

Sheet1.Cells.Interior.Pattern = xlNone


Before:

After:

See also:

• Excel VBA Fill Pattern
• 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