alternative coordinates for creating shapes
Hello,
I'm writing a very simple macro to creat new lines using
ActiveSheet.Shapes.AddLine
and the only problem I have is that the absolute coordinates system is
useless for this particular application - I need to place the lines in
relation to cells, for example, from C2 to H8. Is there a way to do this ?
Of course, keeping them in the correct position if columns to the left or
rows above are added, removed or resized is the follow-up problem.
Anyone got any ideas ?
|