I currently have the following vba
However, if there are multiple instances of "Material" in J it produces a pop up for each instance. I Just need it to pop up once. Not for each instance.
Any help?
VBA Code:
Dim SrchRng As Range, cel As Range
Set SrchRng = Sheets("Brand").Range("J:J")
For Each cel In SrchRng
If InStr(1, cel.Value, "Material") > 0 Then
MsgBox "There is a error which needs to be keyed at lower level. Please filter sheet."
End If
Any help?