Thank you for your help. It works now!

Kind regards,
Sebastiaan.

"Peter T" <peter_t@discussions wrote in message
...
Objects with names that include most types of punctuation are not
accessible
at the Drawingobject level, or in your case as ChartObject. I would
suggest
don't include the brackets or the comma in "Die(2,8)", try instead
something
like "Die_2_8".

But if you really must, or to get you out of trouble, go via Shapes. Eg

Set myChartObject = mySheet.Shapes("Die(2,8)").DrawingObject
or
Set myChart = mySheet.Shapes("Die(2,8)").DrawingObject.Chart

Probably better to start by attempting to set a Shape reference first,
then
the Chartobject or Chart.

I haven't looked at the rest of your code but normally not necessary to
Activate or Select the chart for whatever it is you want to do with it.

Regards,
Peter T