This is what I have written:
Set valrange = Range("O5:O99")
If Not Intersect(Target, valrange) Is Nothing Then
If Target.Formula = "N" Then
MsgBox "Message here"
Basically I am trying to get VB to display a message anytime the formula in column "O" is returning a N (based on an IF statement inside the cell). can't figure out what is missing in the code!
Any help will be greatly appreciated!!