-
How to get the index of ActiveChart
I'm trying to use VBA to change the .Placement setting on the ActiveChart, but this property is only available for ChartObject(index). How can get either get the index number of the ActiveChart or how can I otherwise refer to the ActiveChart using ChartObject. I've tried activechart.name, activechart.index, setting a chart object variable to active chart, all of which error.
Thanks in advance for any help.
Last edited by jyindc; 02-11-2017 at 10:59 AM.
-
I suspect
activechart.parent.placement
is what you want.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules