Ok,

I've got one more question - unrelated, but here goes:

I'd like to be able to have a user move and stretch/shrink a line in a spreadsheet. I give them a line to start with using:

ActiveSheet.Shapes.AddLine(x1,y1,x2,y2).Select

How can I get the new x1,y1,x2,y2 after they have moved and resized the line so I can store in a database and thus redraw these line(s) for them automatically later?