ExcelBanter - ActiveChart location

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - ActiveChart location (https://www.excelbanter.com/excel-programming/435348-activechart-location.html)

Danny[_13_]

ActiveChart location

May I know how to get the Activechart location like "Top",
"Left"...etc.

it must the Activechart, but not "Chart1"... "Shape1".....

Jon Peltier[_2_]

ActiveChart location

You need the position of the chart object which contains the chart:

ActiveChart.Parent.Top

etc.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/

Danny wrote:
May I know how to get the Activechart location like "Top",
"Left"...etc.

it must the Activechart, but not "Chart1"... "Shape1".....

All times are GMT +1. The time now is 02:53 AM.