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