VBA code for pixel coordinates of a grid area

I would like to know the coordinates (in pixels) of the vertices of the grid area of a chart on the screen.
I thought that the plot area coincided with the grid area and therefore I tried to draw a plotarea rectangle, but the two figures were not overlapped, but staggered.

VBA Code:

Set ac = ActiveSheet.ChartObjects(ActiveChartName$)Set pa = ActiveSheet.ChartObjects(ActiveChartName$).Chart.PlotAreaActiveSheet.Shapes.AddShape(msoShapeRectangle, ac.Left + pa.InsideLeft, ac.Top + pa.InsideTop, pa.InsideWidth, pa.InsideHeight).Select

Result (red line):

[ATTACH=CONFIG]68910[/ATTACH]

I would begrateful if you could tell me the correct code
Thanks foryour help

Re: VBA code for pixel coordinates of a grid area

Hi Pike,

Thanks for your reply, but I was wondering something else.
I need (if it exists) a chart property or something similar, that gets an object that represents the grid area contour of the chart (a rectangle with members like .Top, .Left, .Width, .Heigth).
I tried Plotarea, but unfortunately it gives me a rectangle with .Top and. Left not coincident with Grid Area (please see my previous image.jpg - red line)

Best Regards

Re: VBA code for pixel coordinates of a grid area

Hi Pike,
No,my problem is raised by a simple syntax error; I found the correct solution on :
http://www.globaliconnect.com/excel/index.php?option=com_content&view=article&id=370:chart-elements-in-excel-vba-part-1-chart-title-chart-area-plot-area-chart-axes&catid=79&Itemid=475#Plot Area

SOLVED
Regards