leider ist mir ein Fehler unterlaufen. Hier die richtige Beispieldatei
https://www.herber.de/bbs/user/164949.xlsm
Gruß
Siegfried
Sub Pfeile_setzen()
'--Codeteile von Mustafa---
Dim ZelleA As String, ZelleB As String
Dim Ax As Long, Ay As Long, Bx As Long, By As Long, i As Long
Call Pfeile_loeschen
For i = 4 To 15
If Cells(1, i) > "" Then
ZelleA = Cells(1, i)
ZelleB = Cells(2, i)
If i Mod 2 = 0 Then
Ax = Range(ZelleA).Left + Range(ZelleA).Width / 2
Ay = Range(ZelleA).Top + (Range(ZelleA).Height / 2) - 5
Bx = Range(ZelleB).Left + Range(ZelleB).Width / 2
By = Range(ZelleB).Top + (Range(ZelleB).Height / 2) - 5
Else
Ax = Range(ZelleA).Left + Range(ZelleA).Width / 2
Ay = Range(ZelleA).Top + (Range(ZelleA).Height / 2) + 5
Bx = Range(ZelleB).Left + Range(ZelleB).Width / 2
By = Range(ZelleB).Top + (Range(ZelleB).Height / 2) + 5
End If
ActiveSheet.Shapes.AddLine(Ax, Ay, Bx, By).Select
Selection.ShapeRange.Line.EndArrowheadStyle = msoArrowheadTriangle
End If
Next
Cells(1, 1).Select
End Sub
Sub Pfeile_loeschen()
With ActiveSheet
.Shapes.SelectAll
Selection.Delete
End With
End Sub
B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
1 | Pfeil von | L8 | AV8 | C17 | F14 | I11 | ||||||||
2 | nach | AV8 | L8 | F14 | I11 | AA17 |