Excel: Drawing Shapes in Excel 2010 using XY Co-ordinates and Calculating the Subsequent Area of the Shape.

Hello All, I am looking for a method of, having input a finite no. of XY coordinates in Excel 2010, to produce a shape (using straight connectors). I would then like the area of this shape to be calculated. Is there a method that I can use in Excel 2010 to do these? I have a rudimentary knowledge of VBA, so any suggestions would be greatly appreciated. Many Thanks.

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of January 28, 2014.

For more resources for Microsoft Excel