ChartObject index
 

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

ChartObject index
 

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


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

ChartObject index
 

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/


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

ChartObject index
 

ActiveChart.Parent.Index

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Claude wrote:

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