Find by value

> When the find dialog box comes up the default
> is formulas in the look in field.

This is true when Find is first used after the
Excel application is launched. Once the "Look
in" selection is changed to Values it remains as
Values even after the Find dialog is closed.

Hi Jim

You can make the default always Values by using a simple macro like this:

Sub MyFind()
Application.Dialogs(xlDialogFormulaFind).Show , 2
End Sub

You can actually nominate the default for all options by setting the argumnent.

If you need a hand with this, let me know.

Dave

OzGrid Business Applications

The macro worked slick in bringing up the find dialog box. But the find didn't work. To test, I did a CTRL-F to bring up the dialog and the search worked fine. Why doesn't it work with this?