#REF! Error in Chart

Hi All

I am trying to activate a chart in a workbook which has a #REF! error in the series. I deliberately created the #REF! Error in the chart so that I can write a macro which finds charts with #REF errors in it.

I have managed to identify all charts in a workbook with #REF! errors in the series but excel returns an application defined error when I try to do Activesheet.Chartobjects("Chart name").Activate

Is there a work around for this?


Cheers

Hi Andy

I don't need to activate the chart, but I need to be able to get its properties. I can't access the object's properties because the object is a chart that contains a #REF! Error.

I identify the charts with the error by using a For Each Loop to go through all chartobjects in a workbook and read the Series property. I use Instr to determine if there is a #REF! in the series.

For some reason the For Each Loop is able to identify and read the properties of the charts with errors, but a direct call on the chart's property returns an application defined error.

I want to get the error chart's properties to determine the location of the chart without using a for each loop if possible.


Thanks