C
Claude
How do I get an active chart's chartobject index?
MsgBox (ActiveChart.ChartObjects.Index)doesn't work!
MsgBox (ActiveChart.ChartObjects.Index)doesn't work!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Shailesh Shah
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!
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!
S
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/
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
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!
J
Jon Peltier
ActiveChart.Parent.Index
- Jon
- Jon