I think this will be a simple answer, least I hope, but I am drawing a blank at the moment! With this very simple code below, how do I prevent this from occurring in a certain range of cells? I've tried "If Not Intersect(Target, Range("sheet1UV")) Is Nothing Then" but it did not work. Thanks for any help!
Private Sub CommandButton1_Click()
Application.EnableEvents = False
For Each c In Selection
c.Activate
ActiveCell.Formula = "P"
Next c
Application.EnableEvents = True
End Sub