find by column

G

gbusch99

Is there a way to set the default on the FIND tool to
searcy by column rather than by row?
 
J

Jim Rech

There really isn't any good ways to do this. There may be some bad ways,
depending on your Excel version, but it might be best to rely on the Excel
feature that retains your Find direction once set: Manually make it Columns
and then the Find dialog should stay that way for the rest of the Excel
session.
 
D

Dave Peterson

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:=xlByColumns, _
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
 
Top