I have a chart and I want, by using VBA to change the color of series1, but WITHOUT highlighting or activating the chart.
How would this code:
ActiveSheet.ChartObjects("CoasterMainChart").Activate
ActiveChart.SeriesCollection(1).Border.ColorIndex = 45
be able to be turned into something like this:
ActiveSheet.ChartObjects("CoasterMainChart").SeriesCollection(1).Border.ColorIndex = 45
which right gives me an error.
Thanks!
How would this code:
ActiveSheet.ChartObjects("CoasterMainChart").Activate
ActiveChart.SeriesCollection(1).Border.ColorIndex = 45
be able to be turned into something like this:
ActiveSheet.ChartObjects("CoasterMainChart").SeriesCollection(1).Border.ColorIndex = 45
which right gives me an error.
Thanks!