In Excel, I want to draw an arrow from cell B2, right side, to cell C10, left side. This arrow should be coupled to the cells, so if I resize the cells, or cut-paste them to a new place, the arrow should move as well. Is there any way to accomplish this?
p.s. I would settle for a line instead of an arrow if this is easier.
Position the arrow on the sheet and use the grips to adjust the position.
ActiveSheet.Shapes.AddConnector( msoConnectorStraight, _
Range("B2").Left, Range("B2").Top, Range("C10").Left, Range("C10").Top ).Select
Selection.ShapeRange.Line.EndArrowheadStyle = msoArrowheadOpen
Adjust to the cells you want...
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With