Quote Originally Posted by Cyberdude
Incidentally, I found that I could omit the additional args
"LookIn:=xlValues, SearchOrder:=xlByRows, _
LookAt:=xlPart, MatchCase:=False
and, when it worked, it was just as successful as it was with them.
That is because you are using the defaults. By definition, you don't have to specify defaults.