ChartObject index

[Claude]

How do I get an active chart's chartobject index?
MsgBox (ActiveChart.ChartObjects.Index)doesn't work!

 

[Shailesh Shah]

Regards,
Shah Shailesh
http://members.lycos.co.uk/shahweb/

 

[Shailesh Shah]

Try this,

Sub test()
MsgBox ActiveChart.Index
MsgBox ActiveSheet.Index
End Sub

If it is embeded on the sheets
Sub test1()
MsgBox ActiveSheet.ChartObjects("Chart 1").Index
End Sub


Regards,
Shah Shailesh
http://members.lycos.co.uk/shahweb/

 

[Jon Peltier]

ActiveChart.Parent.Index

- Jon