Error when adding title to chart via VBA

[nbuk]

This thread is also posted at: http://www.mrexcel.com/forum/showthread.php?t=482127

I am creating several charts and I get an error when I try to add a title to some graphs.

Please Login or Register  to view this content.

The first 4 graphs are executed perfectly, but when I got to the fifth, I get an error:

"This object has no title"

Does anyone know why this happens on that particular graph (and all others after it). I used the same line in previous charts and it worked just fine.

Thanks!!

[nbuk]

I have fixed the original problem I had yesterday, but today it seems to stop working again.

Here is the code:

Please Login or Register  to view this content.

Get an error at the ".chart.ChartTitle.Characters.Text...." line:

"Could not find specified object"

Any ideas on why this is happening? I have the exact code in different user forms and it runs just fine.

[vikas.bhandari]

There is some problem with either *** Me("Quarter").Value ** or ****Me("year").Value****

The error suggests that you dont have a control by the name off Quarter or year in your user form. If it is there, then please post the spreadsheet here.

Thanks,
Vikas