If it were me, I'd create a single custom shape and then modify the array of vertice data to adjust the drawing appropriately.
I have an example on my website that shows some VBA used to draw custom autoshapes... you might find it useful.
Look for the drawing autoshapes example in the VBA section.
www.XL-Logic.com




Reply With Quote