XlSearchOrder enumeration (Excel)

Specifies the order in which to search the range.

Name Value Description
xlByColumns 2 Searches down through a column, then moves to the next column.
xlByRows 1 Searches across a row, then moves to the next row.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.