Hello!

Is it possible in Excel (2007) to draw a connector line (with or
without an arrow ...) between two cells in a worksheet, so that the
line-tips will follow their cells even when the latter are moved ?

Thanks

Michael

On Feb 25, 7:00*am, Michaelprem123 <michaelprem...@gmail.com> wrote:
> Hello!
>
> Is it possible in Excel (2007) to draw a connector line (with or
> without an arrow ...) between two cells in a worksheet, so that the
> line-tips will follow their cells even when the latter are moved ?
>
> Thanks
>
> Michael

The line will automatically adjust when rows or columns are inserted
or deleted if you select Format Autoshape>Properties>Move and size
with cells ... but you probably already knew that. However there is no
way to easily maintain the connection if a cell is dragged and dropped
to a different place on the worksheet. It is possible to use a VBA
script to delete the old line and redraw a new one but with the work
involved to write the script it may be easier to drag the end of the
line maunally unless it is a frequently recurring issue.

A.