Any way to change default FIND options?

J

joseph

When I do a CTRL+F to find information, the OPTIONS always
is set to Look In Formulas. Is there any way to get is to
default to Look In Values?

thanks.
 
J

JE McGimpsey

One way:

Put this in the ThisWorkbook module of your Personal.xls workbook (or
any other workbook in the XLStart directory):

Private Sub Workbook_Open()
Dim result As Range
Set result = Sheets(1).Cells.Find( _
What:="", _
LookIn:=xlValues)
End Sub

Find options are persistent, whether done in the GUI or in VBA, so doing
a find will set the LookIn value for the next search.
 
Top