April 2006
Beginner
1114 pages
98h 16m
English
workbook.Colors [= setting]
Returns the collection of RGB colors in the workbook’s color palette. Workbooks have 56 colors that can be used. The following code displays the RGB value for each of a workbook’s colors in hexadecimal:
For Each clr In ThisWorkbook.Colors
Debug.Print Hex(clr)
NextRGB values are often expressed in hexadecimal. For example, &hff0000 is red, &hff00 is green, &hff is blue, &hffffff is white, and &h0 is black.
Read now
Unlock full access