Customize Find Dialog Box

[Elaine]

The Find dialog box is defaulted to find by rows, how do I change the default
from rows to columns.

 

[Ardus Petus]

d=application.dialogs(xldialogformulafind).Show (,,,xlbyrows)

HTH

 

[Elaine]

Ardus,

Please expand on answer. Where do I place these instructions.