Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Range("F7")) Is Nothing Then
Target.Offset(0,2)=Range("D7")*Target.Value
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Range("F7:F15")) Is Nothing Then
Target.Offset(0, 2) = Range("D" & Target.Row) * Target.Value
End If
End Sub