alternative coordinates for creating shapes

D

David Macdonald

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 ?
 
D

David Macdonald

David Macdonald said:
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 ?
Click to expand...


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. :(
 
Top