Re: Color Index

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: "Bill" <bill@xxxxxxxxxxxxxxxxx>
Date: Fri, 19 Aug 2005 15:51:01 GMT

Thanks, but I want to know the color that is represented by the
xlColorIndexAutomatic. How do I do that?

"Vasant Nanavati" <vasantn AT aol DOT com> wrote in message
news:%23GQ5zRNpFHA.2504@xxxxxxxxxxxxxxxxxxxxxxx
> -4105 is the constant represented by xlColorIndexAutomatic. If you want
> the color to be blue try to set it specifically.
>
> --
>
> Vasant
>
>
> "Bill" <bill@xxxxxxxxxxxxxxxxx> wrote in message
> news:jOmNe.10056$Je.1311@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> Hello,
>> I have a bar chart is made and then updated. For some reason, when
>> updating, the color changes from blue to purple. When I ask what the
>> color index is for the bar, prior to updating, I get -4105. Not the
>> color index I would expect for blue. I used:
>>
>> Activechart.seriescollection(1).interior.colorindex
>>
>> Any ideas on what is happening? Is the -4105 some default setting?
>>
>> Thanks,
>>
>> Bill
>>
>
>

.

Follow-Ups:
- Re: Color Index
  - From: Peter T
- Re: Color Index
  - From: Bob Phillips

References:
- Color Index
  - From: Bill
- Re: Color Index
  - From: Vasant Nanavati

Prev by Date: RE: Passing variables from one sub to another
Next by Date: Re: Getting values from anotjer workbook
Previous by thread: Re: Color Index
Next by thread: Re: Color Index
Index(es):
- Date
- Thread

Relevant Pages

Re: Color Index
... Vasant ... > I have a bar chart is made and then updated. ... > color index is for the bar, prior to updating, I get -4105. ...
(microsoft.public.excel.programming)
Color Index
... I have a bar chart is made and then updated. ... the color changes from blue to purple. ... index is for the bar, prior to updating, I get -4105. ... Not the color index I ...
(microsoft.public.excel.programming)