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>
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>