If value exists, go to end. Otherwise continue.

[mvparker79]

Basically I want the code to start by looking in the sheet "dump" for the string "Check Figure". If the string exists, then it displays a message then ends the macro. If the value does not exist, then just continue running the macro. This should be very simple but I'm drawing a blank. Here is what I have so far.

    If Dump.Cells.Find(what:="Check Figure") = "Check Figure" Then
    Fail = MsgBox("Import new data")
    GoTo FailEnd
    Else
    End If