Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = 0
If [C5] >= 3000 Then
arr = Range("F10:F14")
End If
If Range("d10") = "" Then
Range("d10:d14") = arr
End If
Application.EnableEvents = 1
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = 0
If [C5] >= 3000 Then
arr = Range("F10:F14")
End If
If Range("d10") = "" Then
Range("d10:d14") = arr
End If
Application.EnableEvents = 1
End Sub