| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ChartObject index
How do I get an active chart's chartobject index?
MsgBox (ActiveChart.ChartObjects.Index)doesn't work! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error when create chartobject on line ".HasTitle = True" | Charts and Charting in Excel | |||
| Delete old chartobject and create a new named one? | Charts and Charting in Excel | |||
| Selecting chartobject without index no. | Charts and Charting in Excel | |||
| Fill screen with chartobject by zooming? | Charts and Charting in Excel | |||
| How can I change size of the picture without changing chartobject? | Charts and Charting in Excel | |||
Hybrid Mode
