Move a named chart

Hi, I have generated 3 charts which all go onto one sheet. I want to position them in specific places. This is my code:

Please Login or Register  to view this content.

It all works until it comes to positioning the charts. Error says "The item with the specified name wasn't found" so I tried using the name "N_Chart1" instead of "Dissolved Oxygen" but it didn't work.

Any ideas?
THanks
Katie xx

Also: http://www.mrexcel.com/forum/excel-q...med-chart.html

Originally Posted by cytop

Also: http://www.mrexcel.com/forum/excel-q...med-chart.html

yeah i posted that... why have you linked it?

Rules, and you agreed to them when you joined...

8. Don't cross-post without a link. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. Expect cross-posts without a link to be closed.

For info MrExcel has the same rule, as does every other board like this.

Well I clicked "forum rules" at the bottom right of the page and there was no real information, so I went ahead.
I will remember that.

Originally Posted by Andy Pope

Please Login or Register  to view this content.

The object reference is destroyed when the location is changed so you need to reset it.

Thanks so much!
My only question is.. why can't I use the names (eg "temperature")? What can I do with these names? If nothing I may as well delete 'N_Chart1.Name' lines...
xxx

Originally Posted by Andy Pope

Because the sheet name is not retained. The object is given a new name, infact they all probably have the same name, Chart 1.

You might want to name the newly created chartobjects for future reference.

Ok thank you Andy.
From what you just said, I expected this code to work (it doesn't )

Please Login or Register  to view this content.

ok i misread what you said. so what you said was in agreement with what i said : i may as well remove those earlier .name lines if they're irrelevant. thanks