Embedded chart location address

  • Thread starter Thread starter avi
  • Start date Start date
A

avi

Hello,

Is there a VBA way to return the Range address of an embedded chart.
location on the sheet?

I mean by that the location of the chart as an object itself and not
of its series

Thanks
Avi
 
The chart object is like a shape object and basically floats above the
sheet. You can get the Top and Left properties of the ChartObject, which
will give you an anchor point, in points, but I don't believe you will get
an address in terms of a cell reference.
 
Back
Top