When we do a search using .find:
and we need to know if something was found, what's the difference between "If Not sought Is Nothing Then" and "If sought Then"?Code:Set sought = Sheets(i).Cells.Find(what:="Hello World", After:=Range("B3"), LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False)
Thanks




Reply With Quote
