Excel vba chart build problem.

[wimblejon]

Hi there,

Has anyone come across this weird phenomenon?

I have some code in a macro as follows:

With ActiveChart
..HasTitle = True
..ChartTitle.Characters.Text = "SERVICE PACKAGE UTILISATION"
..ChartTitle.Top = 13
..ChartTitle.Left = 13
End With

.....but it doesn't put the title to the left when I run the macro
using 'Run' or 'F5'. If I step through the code using "Step into" or
'F8' then it works fine!

Any ideas?

Thanks,

Jon

 

[NickHK]

Are you using XL 2007 ?
Some report strange (different) behaviour with that version and charts.

NickHK

 

[wimblejon]

NickHK,
Thanks for the reply.
No, I'm on W2k SP4 with Excel 2003 (11.6...) SP2

Jon

 

[Jon Peltier]

Works for me, Excel 2003 SP2, WinXP SP2.

- Jon