Chart Objects vs Chart Number

[MrLookout9]

Hello and thank you for your expertise.

I am trying to activate Chart 39 on sheet1.


Sheets("Sheet1").ChartObjects(39).Activate

When I run my macro, this line errors out and I get an Application or Object defined error.

I don't believe the problem is with the Sheet. If I change the ChartObjects(1), The correct sheet is chose, but the wrong chart is activated (Chart 44 for some reason).

Are ChartObjects numbered the same as the Chart #?

Any thoughts?

 

[Norie]

Chart 39 is unlikely to be the 39th chart on the sheet.

Using ChartObjects with a number you are trying to refer to a chart object via it's index in the ChartObjects collection.

Have you tried using the name, 'Chart 39'?

Sheets("Sheet1").ChartObjects("Chart 39").Activate