jyindc
02-11-2017, 10:17 AM
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.
Thanks in advance for any help.