XL97: Border Color of Lines Returns Incorrect RGB Value When Border Color Is Set to Automatic (237277)



The information in this article applies to:

  • Microsoft Excel 97 for Windows

This article was previously published under Q237277

SYMPTOMS

In Microsoft Visual Basic for Applications, when you use the Color property to return the border color of a series in a Microsoft Excel chart, it returns black (0) if the border color is set to Automatic. For example, the following code returns 0 (zero):
ActiveChart.SeriesCollection(1).Border.Color
				

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Modification Type:MinorLast Reviewed:10/11/2006
Keywords:kbbug kbdtacode kbfix KB237277