I have a worksheet where I want a message box to appear when the letter "A" appears in the range I37:I69. I used to following code to accomplish this:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Range("I37:I69").Find(what:="AA", LookIn:=xlValues, lookat:=xlWhole...