Check Range of cells for a word.

[Trilback]

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

[k64]

Try this:

Please Login or Register  to view this content.