Posted to microsoft.public.excel.programming

ojv[_2_]

external usenet poster

Posts: 53

Color problem

I am trying to set the color on a shape object to the same color as the
border color for a series object. I want to execute a statement akin to:

shLI.Line.ForeColor.SchemeColor =
ActiveChart.SeriesCollection(i).Border.ColorIndex

I know the above code fails but how can I translate the Border.ColorIndex to
an identical color permitting setting of SchemeColor? Any help appreciated.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Tab color problem	Shari	Excel Discussion (Misc queries)	5	March 7th 08 03:26 PM
Problem displaying color	mgossard	Excel Discussion (Misc queries)	0	February 9th 08 05:15 PM
Background color problem	Doug Sanders	Excel Discussion (Misc queries)	3	February 10th 06 06:29 AM
A different "Fill Color" problem	JKD	Excel Worksheet Functions	1	November 1st 04 10:21 PM
vlookup color problem	bob	Excel Programming	1	August 14th 03 04:01 AM

All times are GMT +1. The time now is 12:08 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us