Edit Find defaults to rows

[Ken Schmidt]

Hi,
Am looking for a way to change the default Edit-Find by
rows and formulas to bu columns and values. Help text
advises that columnar searches are more efficient; there
MUST be a way to select that as default. Help, please.
TIA Ken.

 

[Bob Umlas]

Put this in the workbook_open event of your personal.xls:

Private Sub Workbook_Open()
On Error Resume Next
n = Cells.Find("XYZ", searchorder:=xlByColumns).Row
End Sub

It will find nothing, but it will "set" the default finds to search by
columns.

Bob Umlas
Excel MVP