Actually I'm "glad" you persevered with the belief of your perceptions,
despite any hint I doubted (not intended) !

I think this deserves the status of "bug", albeit a mild one with an easy
workaround. I hadn't noticed it before because I only return palette colours
in objects that cannot accept an RGB format.

I'm also surprised never to have come across mention of it in this ng or
elsewhere, which is not to say it isn't documented.

I don't know of any "effective" means to report bugs. I've tried in the past
with much more serious issues regarding the palette & VBA.

Regards,
Peter T


"AnExpertNovice" wrote in message
...
Well, I'm "glad" you could confirm this feature on your system. The
problem
exists, as one would assume, in both Excel 2000 under Win 2K and 2002
under
Win XP.

Your tests were interesting because you were able to replicate with code
what I was producing with manual actions.

As for the conclusion
Or apply some format (even same format), but as Font can have mixed
formats
best to apply to .Interior.

This still breaks when code execution is stopped (debug.assert, stop,
break
point, and other errors) so determining the color of the color index
appears
to be the only decent solution.

Take care. Thanks for the conversation.

--
My handle should tell you enough about me. I am not an MVP, expert, guru,
etc. but I do like to help.

<snip