alternative coordinates for creating shapes

[Guest]

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 ?

 

[Guest]

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 ?

I think the solution is somewhere in this threa
http://www.microsoft.com/office/com...=en-us-excel&lang=en&cr=US&sloc=en-us&m=1&p=1
but darned if i can figure it out.