Excel VBA, Apply Fill Pattern to Rows

Jump To:


Apply Fill Pattern to Row:

The following line of code applies the Reverse Diagonal Stripe fill pattern to row 3:

Rows(2).Interior.Pattern = xlDown

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

Before:

Excel VBA, Column Fill Pattern Before

After:

Excel VBA, Row Fill Pattern, After


Modify Row’s Fill Pattern Color:

The line below changes the color of the fill pattern for row 3 to green:

Rows(3).Interior.PatternColor = ColorConstants.vbGreen

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

Before:

Excel VBA, Row Fill Pattern, After

After:

Excel VBA, Row Fill Pattern, After Color
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

Leave a Reply

Your email address will not be published.