Thanks Peter, but I noticed that when I updated the list.

Bob

"Peter T" <peter_t@discussions wrote in message
...
Hi Bob,

For the sake of completeness there was "another" typo in the original list

20 Light Turquoise is same as colorindex 34, but 21 Dark Purple is a
unique
colour.

Regards,
Peter T


"Bob Phillips" wrote in message
...
Thanks for those fill-ins Peter, will update my list.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Peter T" <peter_t@discussions wrote in message
...
Hi Pete,

The "default" chart colours are also named though 10 of these are
duplicates
of other colours in a default palette.

17 # Periwinkle
18 Plum
19 # Ivory
20 # Light Turquoise
21 Dark Purple
22 # Coral
23 # Ocean Blue
24 # Ice Blue


25 Dark Blue
26 Pink
27 Yellow
28 Turquoise
29 Violet
30 Dark Red
31 Teal
32 Blue

# denotes non-duplicated colour.

There's no direct way to return these names, I do it by comparing the
long
colour value in a lookup table of values & names.

Regards,
Peter T


"Peter Rooney" wrote in
message
...
Good morning, all!

Is there any way in VBA to trap the name of the interior.colorindex
values,
so, for any selection, I can msgbox the name of the fillcolor e.g.
Red,
Blue,
Rose, Tan etc?

The reason for this is that colors 17 to 32 can also be used, but
they're
not on the toolbar palette, and I want to know if Excel has names
for
them.

Yes, I KNOW I need to get out more! :-)

Thanks in advance!

Pete