hi,
IF I SELECT ANY CELL FROM RANGE F10:F1000 AND PRESS DELETE KEY THEN THIS CODE GOES TRIGGER
I DON'T WANT TRIGGER BELOW CODE IF PRESS DELETE KEY
THANK YOU
HOPE SOMEONE WILL HELP
![]()
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub If Not Intersect(Target, Range("F10:F1000")) Is Nothing Then If Range("$M$3") > 0 Then MsgBox "Number Is Not Valid " & Target.Value Application.EnableEvents = False Target.ClearContents Application.EnableEvents = True Exit Sub End If End SuB
Bookmarks