This does not seem to be working and I do not know why.

If Range("T3:T999").Value = "Duplicate" Then

MsgBox "It did work"

Else

MsgBox "What happened??"

End If