Any of you who have tried to format a chart using VBA will know what a pain in the ass it is.
But do any of you know why
[
CODE]with FetchChart
.PlotArea.Height = 200
End With[/CODE]
sets .PlotArea.Height to whatever Excel feels like,
while
sets it to almost the right value (+/- Excel's tweakings)?With Sheets(FetchChart.Parent.Parent.Name).ChartObjects(FetchChart.Parent.Name).Chart .PlotArea.Height = 200 End With