Hi,
New to this forum, so had a good search first to see if I can find anything similar, but can't find anything that fixes the problem!
The problem: I am using VBA to generate some charts on a Worksheet from data held in another Workbook. Everything works great - formatting, the works - but only when stepping through with the VBA Debugger or setting a BreakPoint!! If I run the code without it stopping, the format of the chart is corrupt.
The point of failure appears to be associated with changes to the "PlotArea". If a breakpoint is set on changing, say the "Top" parameter, then run is clicked again, the chart is fine!
The code section is:
I commented out the assignments from variables - just to be REALLY sure!!' Set the PLOT AREA as required With ActiveChart.PlotArea .Top = 12 ' iPlotAreaTop .Height = 78 ' iPlotAreaHeight .Left = 9 ' iPlotAreaLeft .Width = 243 ' iPlotAreaWidth End With ' ActiveChart.PlotArea
Any help would be greatly appreciated - this is becoming a REAL pain!!
Bookmarks