Find and Replace

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hi

Is it possible to retain the options within the Find and Replace
dialogue box?

For example, I wish to always look within 'values' in the 'look in'
setting.
Whenever I open up the Spreadsheet aftering saving the file I find
that it automatically reverts to the devault 'look in formulas'
setting.

Excel 2000

Many thanks

Mark
 
I don't think there is any way to make Excel retain that preference in the
Find dialog. The only solution I know of is to use a macro to open the Find
dialog. That way you can preset options:

Sub PresetFind()
Application.Dialogs(xlDialogFormulaFind).Show arg2:=2
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS word Find and Replace using Regex - Help required 0
Find/Replace MSWord wildcard characters from within Excel 6
Find and Replace in VBA 3
Faster way to find and replace? 1
Find and Replace Within a Range Versus Workbook - Suggestion 2
XL2003 find and replace broken? 2
Find and Replace Macro 2
Find and Replace 4

Back
Top