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 ?