xlSearchOrder

Specifies the order in which to search the range.

xlByColumnsSearches down through a column, then moves to the next column (2)
xlByRowsSearches across a row, then moves to the next row (1)

xlByColumns
Searches down through a column, then moves to the next column (2)
xlByRows
Searches across a row, then moves to the next row (1)


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top