Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Moving Shapes with the mouse | New Users to Excel | |||
Minimum Distance Calculation using Array and Geographical Coordinates | Excel Discussion (Misc queries) | |||
Radar Plot using geographical coordinates | Charts and Charting in Excel | |||
How can i get more 3D shapes for Auto shapes in excel? | Excel Discussion (Misc queries) | |||
How can i get more 3D shapes for Auto shapes in excel? | Excel Discussion (Misc queries) |