Need help with message box.
 

Or, to use your references:

If Cells(22, 11).Value = "QS" Then
MsgBox "New code"
Exit Sub
End If

if you do not want this to be case sensitive:

If UCase(Cells(22, 11).Value) = "QS" Then
MsgBox "New code"
Exit Sub
End If


---
Regards,
Norman



"Norman Jones" wrote in message news:...
Hi Pat,

Try:

If Cells(1, 1).Value = "QS" Then
MsgBox "New code"
Exit Sub
End If


---
Regards,
Norman