Private Sub Worksheet_Change(ByVal Target As Range) Dim KeyCells As Range Set KeyCells = Range("E1") If Not Application.Intersect(KeyCells, Range(Target.Address)) Is Nothing Then Call schreibe_den_bereich_neuer_zellenwert("D7:F12") End If End Sub