Excel VBA, Row Fill Color

The following line changes the fill color of the first row to blue:

Rows(1).Interior.Color = vbBlue

Same as the previous line but instead of using the blue color constant it uses the blue color code

Rows(1).Interior.Color = 16711680

For more information about working with colors in VBA for Excel please see VBA Excel, Colors.


Excel VBA, Color Fill, Rows, Before


Excel VBA, Color Fill, Rows, After

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. Required fields are marked *