VBA - Obtaining source-range of a chart

[PiVi]

Hello there,

I'm new here.

The reason I became member is that I am totaly stuck in my attempt to the following:
I produced a VBA macro in Excel with the intention to examine a test pupils of me have made. One of the items to examine is the chart they have to make.
To control whether or not they picked the right source-range for this chart I have to retrieve the used source-range. Btw it's a pie-chart.
Does anyone know what VBA-code I can use for this problem?

All suggestions are welcome!

PiVi

 

[mikerickson]

Something like

MsgBox ActiveSheet.ChartObjects(1).Chart.SeriesCollection(1).Formula

 

[PiVi]

Thanks, Mickerickson

Especially the part 'Formula' was the thing i needed.
The part 'Chartobjects(1).Chart' produced error 1004.
I try to translate from the Dutch version: Property ChartObjects of class Chart cannot be collected.

But without that part it works just fine!
Tanks again.

PiVi

 

[mikerickson]

That syntax is for a chart on a worksheet. The syntax is different if the chart is its own sheet.

MsgBox Sheets("Chart1").SeriesCollection(1).Formula

 

[PiVi]

Thanks

That's exactly what I made of it!

PiVi