Very wierd problem. Please help
Hi
I find that anything that involves updating charts can always do with
a sprinkling of DoEvents. So put
DoEvents
in after you do the .HasTitle = True. No harm to put it in after
other .HasTitle lines too.
I think (and it is a wild guess) that the code runs ahead trying to
manipulate the Title object before it is properly created. The
DoEvents forces the object to be properly created before you
manipulate it.
hope it helps!
Paul
On May 15, 4:30 am, Francis wrote:
I wrote a piece of code to generate a bunch of charts(40) in a
worksheet. It was running smoothly and generate some beautiful charts.
However, last Thursday it stops due to a run-time error while running,
23 charts has been generated. The error message is "Unable to set the
HasTitle property of the Axis class". It is very wierd because the
code is in a loop and it pass the first 23 charts and block the 24th.
....
|