MarkerBackgroundColorIndex = xlAutomatic
If I create a chart in my code and I do not specifically set the
MarkerBackgroundColorIndex for the series it is set to xlAutomatic by default.
How can I extract the actual colorindex that excel chooses?
Debug.Print ActiveChart.SeriesCollection(I).MarkerBackgroundCo lorIndex
just gives me the code for xlAutomatic (-4105 I believe).
Thanks
The Doctor
|