Of course, had it in the wrong place! LAST question, I promise....when there is nothing found I would like a msgbox. I've added this code after set rng but it bring back an error...any ideas? Really appreciate your help so far
    If Rng Is Nothing Then    MsgBox "Nothing Found"
    Exit Sub
    End If