Jim Vance said:
In Excel 2004, when one brings up the Find dialog, the search will be
performed by rows unless one changes this choice to columns. Is there a way
to change the default to search by columns? Thanks in advance for all
replies.
The by Rows or by Columns property of the Find method is persistent, so
if you use by columns, the next time you bring up the Find dialog, by
columns will be selected.
By default, by Rows is set when XL starts up. You can use VBA to modify
the setting on startup if you put something like this in the
ThisWorkbook code module of your Personal Macro Workbook or another
Add-in (see
http://www.mcgimpsey.com/excel/modules.html
if you're unfamiliar with where to put macros). If you CTRL-click the
workbook header and choose View Code, the Visual Basic Editor will open
with the ThisWorkbook module selected:
Private Sub Workbook_Open()
Dim a As Range
On Error Resume Next
Set a = ThisWorkbook.Sheets(1).Cells(1, 1).Find( _
What:="A", _
SearchOrder:=xlByColumns)
End Sub
This will conduct a search when XL starts up, setting the SearchOrder
property. The next time you invoke Find, the by Columns setting will be
used.
