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:
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:
After:
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