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.


"avi" wrote in message
...
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

avi;583029 Wrote:
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


Code:
--------------------

Sub blah()
With ActiveSheet.ChartObjects("Chart 1")
MsgBox Range(.TopLeftCell, .BottomRightCell).Address
Range(.TopLeftCell, .BottomRightCell).Select
End With
End Sub

--------------------


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: 558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=161354

Microsoft Office Help

Looks great!!!

Thanks

Avi