"David Cuthill" wrote in message
[snip]

Thanks again Peter but the change still results in the same error. I
place
the suggested line immediately below Set nds = myArcShape.Nodes
If literally(?) "Immediately below" the 'Set nds =' line I'd expect you
now
to get the error on the new 'SetEditingType' line because ndStart
doesn't
refer to anything, so move it below the 'Set ndStart =' line or, as I
should have better clarified, just above lines that attempt to return
the
points coordinates.

BTW - had the points ever been manually edited?

Peter T
Thanks - the placement of the line made the difference and it is working.
I
did manipulate manually the "angle" of the arc before running the code
and
it still works. It looks like the set editing type removes the ability to
manipulate the angle of the endpoints of the arc and attempting to edit
the
points afterward then the shape is no longer considered an arc - which is
okay as it just needed to be static after this manipulation.
============
Glad it's working.
If by "angle of the arc" you mean "angle of the shape" that's not the
same
as editing the points.

PT

Peter

I don't me the angle of rotation of the shape but rather when you edit the
endpoint points position of an arc you are changing the angle (or at least
that is the way I understand it).

I captured an image of what I mean in order to make my point clear but I
can't see how to upload it.

thank you

David

Ah, it's confusing as that is yet a third way of editing the arc/shape. But
if I understand correctly that's not 'edit points'. In most Excel versions
right click the shape and "Edit Points". In 365 and 2019, select the shape,
on the Ribbon, Shape Format / Insert Shapes / Edit Shape / Edit Points.

PT