How to fill a range of cells with predefined in command bar colour?

[vladk]

Hi,

I tried to use CommandBars("Drawing").Controls("Fill Color").Execute, but the method fails. Tooltip property displayes colour description but not it's colour ID.

Can anybody help?

Thank you
vladk

 

[SkipVought]

vladk,

Your problem is not clearly stated.

Please state what you are attempting to do in plain language, like, "I want to change the background of a range to a green."

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}