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:

    ' 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
I commented out the assignments from variables - just to be REALLY sure!!

Any help would be greatly appreciated - this is becoming a REAL pain!!