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 ?

alternative coordinates for creating shapes
 

"David Macdonald" wrote:

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 thread
http://www.microsoft.com/office/comm...=en-us&m=1&p=1
but darned if i can figure it out. :(