ChartObject

[LDale]

I'm currently using the following code but it is only when create the first chart. I need it to be dynamic. <o></o>
ActiveSheet.ChartObjects("Chart 1").Activate <o></o>
<o> </o>
I also have tried the following but they don't work either.<o></o>
<o> </o>
ActiveSheet.ChartObjects("Chart " & NC).Activate<o></o>
ActiveSheet.ChartObjects("Chart " & chartno).Activate <o></o>
<o> </o>
Could use some help.<o></o>
Thank you.<o></o>

 

[shg]

Which chart are you trying to activate? If one just created by code, post the code.

 

[LDale]

Each time I go to a different worksheet in the workbook and run the macro it will create a chart on the data for that worksheet. Regardless of how many worksheets I have. I am trying retrieve the chart number that excel assigns to the new chart.

 

[Jon Peltier]

This naming of charts can cause problems.

You could either name the chart as you create it, or use something like this, which will activate the last chart created:

ActiveSheet.ChartObjects(ActiveSheet.ChartObjects.Count).Activate