Workbook.Colors (Excel)

Returns or sets colors in the palette for the workbook. The palette has 56 entries, each represented by an RGB value.

Colors (Index)

Index: The color number (from 1 to 56). If this argument isn't specified, this method returns an array that contains all 56 colors in the palette.

ActiveWorkbook.Colors(5) = RGB(0,0,255)'blue