On May 29, 11:13*am, Joel wrote:
The VBA Find dialog will inherit the worksheet setting, I didn't think the
Find function would.

An excerpt from the online help
"The settings for LookIn, LookAt, SearchOrder, and MatchByte are saved
each time you use this method. If you don’t specify values for these
arguments the next time you call the method, the saved values are
used. Setting these arguments changes the settings in the Find dialog
box, and changing the settings in the Find dialog box changes the
saved values that are used if you omit the arguments. To avoid
problems, set these arguments explicitly each time you use this
method."