ChartArea.left reporting incorrectly?
Interesting tip Jon, thanks for that. I employed it prior to the With - End
With statement I was using on each successive plot to format and orient it.
Previously it was misalinging the final two plots created... with DoEvents it
only misaligned the last plot. I added a DoEvents immediately after the
realignment as well, and Excel turned ScreenUpdating back on (!). Figured I
was in over my head at that point.
In the end I've hardcoded the numbers since they'll nearly always be
constant. Thanks anyway.
|