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

[The_Engineer]

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.

 

[jrickards]

OK, I've been playing with the code and the source data that I'm going to be using. What I'm not clear on is what determines the placement of the drawn figure in the Y orientation.

 

[jrickards]

Nevermind, solved!