Code to return the data a chart is based on

D

dracstorey

Anone know of an method in VBA which will return the data series an
existing graph or chart is based on?

I cannot I find any code to return the data series that a chart is
based on. (i.e. return "C4:C7"). It seems an obvious thing to want to
do but ...


Andrew
 
D

dracstorey

Many thanks Tom. I'm glad he says there is a serious flaw (I thought I
was going mad!). I will try his code and hopefully it will solve the
problem.

Thanks again

Andrew
 
D

dracstorey

Problem nearly solved. I have very nearly integerated the code into
mine. Just a couple of bugs for me to deal with but therange is indeed
returned!

Many thanks

Andrew
 
Top