Hello,
In earlier version of VBA Excel (2003), the nodes property exist for Line shapes.
So, to get the start and end point's co-ordinates of any shape(created earlier), we can get it from "Shape.Nodes(1).points" and "Shape.Nodes(2).points.
But in new version (2019), there is no nodes for line shape.
How to get the co-ordinates of line now?
In my following Example, I created 2 lines:
ActiveSheet.Shapes.AddLine(50,50,200,200) (looks like "\")
ActiveSheet.Shapes.AddLine(50,200,200,50) (looks like "/")
Now for both the shapes, the output of shape.left, .top, .width, .height , .horizontalFlip, .VerticalFlip are same.
So , now how we can get the co-ordinates for both the lines?
Thanks,
Somesh
