Embedded chart location address
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 |
Embedded chart location address
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 |
Embedded chart location address
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 |
Embedded chart location address
Looks great!!!
Thanks Avi |
All times are GMT +1. The time now is 01:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com