Fixing Find (Ctrl F) parameters

  • Thread starter Thread starter slopey
  • Start date Start date
S

slopey

I use FIND 'Ctrl F' to find data in a large Excel 2002 spreadsheet.
Because I have to go in and out of it a lot, it would be handy to se
the FIND (Ctrl F) 'Look In' options permanently to 'Value' on tha
sheet so that I do not have to click on it every time.

Thank
 
Maybe you could have a dummy workbook that you put in your XLStart folder that
does a Find with the settings you like:

Option Explicit
Sub auto_open()

Worksheets("sheet1").Cells.Find What:="", After:=ActiveCell, _
LookIn:=xlValues, _
LookAt:=xlPart, SearchOrder:=xlByRows, _
SearchDirection:=xlNext, MatchCase:=False

ThisWorkbook.Close savechanges:=False

End Sub

The workbook opens, does a find (to fix your settings) and then closes to get
out of the way.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Back
Top