On Mar 6, 11:18*am, Maury Markowitz wrote:
Ok, it turns out that if you simply select "Values" in the "search in"
popup instead of "Formulas" it ignores hidden fields. I'm sure someone
at MS thought this made sense.

So now the question is whether or not there is a switch somewhere that
I can use to select this as the default operation when the sheet is
open.

Maury

You may want to investigate the Find Method in the VBE help. Here is
a cut and paste from the 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."

I hope this helps in some way.

Best,

Matt Herbert