Thread: Color problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Color problem

Have you tried

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ojv" wrote in message
...
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.