One more thing - Pete - I note you in a couple of places you almost
"excused" your self for asking this question. You shouldn't!

Bear in mind a very significant proportion of the population have some
degree of colour vision impairment. Where appropriate naming colours can be
very useful. Though I'm not sure how intuitive the name "Periwinkle" is!

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