On Sep 16, 4:19*am, chrisdev wrote:
Till Excel 2003, the below command was used for retrieving the
available colors to be used,

activeworkbook.colors(1...56)

Returns or sets colors in the palette for the workbook. The palette
has 56 entries,

Now with Excel 2007+2010, the same command can be used but it does not
return the theme colors.

Which command can I used in order to retrieve the colors given in HOME
ribbon, FILL COLOR (background) option which includes 70 colors (60
theme colors + 10 standard colors)?

Thanks a lot in advance!

Can you try activeworkbook.colorindex( )