Jump To:

• Apply Fill Pattern to Column
• Modify Column’s Fill Pattern Color

Apply Fill Pattern to Column:

The following line of code applies the Reverse Diagonal Stripe fill pattern to column B:

Columns(2).Interior.Pattern = xlDown

Note: The intellisense may not work while working with the Columns member.

Before:

After:

Modify Column’s Fill Pattern Color:

The line below changes the color of the fill pattern for column 2 to green:

Columns(2).Interior.PatternColor = ColorConstants.vbGreen

Note: The intellisense may not work while working with the Columns member.

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