Excel VBA 2016 Changes in Chart Commands

[claywhit]

Hi All,

I have an Excel VBA macro that runs perfectly fine in 2010 and 2013, however it bombs in 2016 when it encounters the setting of the plot size characteristics. Following are the specific settings in my code that give me trouble now:

.PlotArea.Width = 630
.PlotArea.Left = 30
.PlotArea.Top = 45
.PlotArea.Height = 470

Any suggestions as to the problem and how to fix.

Many thanks,
Clay

 

[Domenic]

Make sure that the references to the properties are qualified with a reference to the Chart object, not the ChartObject object. Here are some examples...

With ActiveSheet.ChartObjects(1).Chart
    .PlotArea.Width = 630
    .PlotArea.Left = 30
    .PlotArea.Top = 45
    .PlotArea.Height = 470
End With

or

With Worksheets("Sheet1").ChartObjects("Chart 1").Chart
    .PlotArea.Width = 630
    .PlotArea.Left = 30
    .PlotArea.Top = 45
    .PlotArea.Height = 470
End With

Hope this helps!

 

[claywhit]

Domenic,

Thanks for your assistance. I intended to find a solution that still allowed my to utilize the old Charts.Add term. After some trial and error, I found out that all I needed to do was simply add a ".Activate" (i.e. ActiveChart.Activate) command ahead of the .PlotArea commands.

Thanks for your efforts.
Clay