Activechart Location
 

Hi, I have a problem to determine the activechart Top and Left.

Normally, we can use

Activesheet.shape(x).selection
with selection
.Top = xxx
.Left = xxx
end with

however, my worksheet has a lot of charts. How to determine to
achivechart Top and Left when selected chart can be difference. eg,
user click chart 1, then macro determine the top/left; user click
chart 10, then macro determine..... and so and so. Help. Thanks.