Not an easy one, see what John Walkenbach has to say...
http://j-walk.com/ss/excel/tips/tip83.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"HD"
wrote in message
Hi,
I am trying to figure out if anyone knows how to have excel (vba) code to
return the source location of where the chart is getting its data from.
Ex: if i were to select a chart it will highlight the cells where it is
getting its data from to plot. what is the command (code) to have it return
the range ( : ) into a variable in vba ?