Look up Colorindex Property in VBA Help, and you will see them there.

Or else you could run this code snippet to see them. Run it on a blank
worksheet.

For i = 1 to 56
Cells(i,1).Interior.ColorIndex = i
Next

The row number gives the the index number

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"EV" wrote in message
...
Is there a list of all the color indexes somwhere ... just so I can pick
up
all the colors easily?

Thanks again
Andy