Find SearchOrder?

  • Thread starter Thread starter John
  • Start date Start date
J

John

the SearchOrder parameter doesn't seem to do anything in the Find
method. Whichever I use (XlByRows, XlByColimns) it seems to search in
the same way.

I am assuming that xlByrows would have it search row by row and
XlByColumns search Column by Column. Am I in error? I try both but it
searches by columns with both parameters.

John
 
By row and by column works as you have described it. Place "A" in Cells A1,
B5 and C1 of a blank sheet. Do a find for "A"

By Rows the order is
A1, C1, B5
By columns
A1, B5, C1

Or at least that is how it works for me...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

lastrow function help 6
Problem with a loop and column references 27
Return last row no. of column with blanks at top 7
Help with Correct Call for Ron de Bruin's "RDB_Last" to Find Last Row in a Column 1
why does cell.replace work with byrows and not with bycolumns 1
Getting Excel Find to Default to Searching Workbook not Sheet 3
Two column deletion 16
Set Column choice to a variable from a Drop Down 4

Back
Top