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