Interesting VBA problem.

[xamination]

I am writing a program which takes data from multiple charts and combines them into one singular chart. Everything seems to be working fine, until I get to these last two lines

ActiveChart.HasTitle = True
ActiveChart.ChartTitle.Text = chartName

Now, if I run the macro as is, I get an error message telling me "The object has no title." Hovering over ActiveChart.HasTitle says it is set at false. HOWEVER, if I put a stop in a few lines before, and step through these lines, everything works fine, no problem. I even put a do until loop around "activechart.hastitle = true" to make sure it was setting it to true.

It seems that if I run through it as normal it will throw an error. But if I step through it it won't. Whats causing this error, or what would be a work around at least?

Thanks in advance

 

[Greg Truby]

Sometimes things get a little strange depending on whether what you have is a chart or a chart object. Try the following:

ActiveChart.chart.HasTitle = True
ActiveChart.chart.ChartTitle.Text = chartName

If that fails - try binding an object variable to the chart instead of trying to use the ActiveChart object and do your manipulations on the bound chart-object variable.

 

[xamination]

Tried all the methods you suggested, nothing has worked. For whatever reason the hasTitle value keeps being set to False, no matter what I do to set it True...
Anyone else have any ideas?

 

[Greg Truby]

But you can go in and do what you want to do manually? It's not a case where it's actually not possible. Just a case where VBA is being cantankerous?

 

[xamination]

"cantankerous"? Nice word. And yes. If I step through the lines of code, there seems to be no problem. But when it runs on it's own, it just... decides to be difficult.

 

[Greg Truby]

Try sticking a DOEVENTS statement before the .HasTitle line.

 

[sethmac86]

Had the exact same problem today, did this and it worked fine ( I am using excel 2010)

instead of
ActiveChart.HasTitle = True

use
ActiveChart.SetElement (msoElementChartTitleAboveChart)

this worked for me when running the code.

 

[xamination]

That seems to have worked, thanks!

 

[Greg Truby]

Which worked? the DoEvents? Or the .SetElement(...) Others might need to know. :wink:

 

[xamination]

The .SetElement(...) method. Still have no idea why I was getting the problem I was, but it's water under the bridge IMO