PDA

View Full Version : .Find() Arbitrary Search Direction



MINCUS1308
06-26-2017, 06:53 AM
If I, or coworker #1, run my code the .find search direction is top to bottom. (on windows 10)
If coworker #2 runs the code I believe the search direction is bottom to top. (on windows 7)

I didn't explicitly say which direction to search the range and I know I could have -
but why is it just coworker #2's machine that seems to want to search bottom to top?


Set S4PRODIDAddress = Sheet4.Range("Table_Tablix1").Find(MyBatchNumber, LookIn:=xlValues, LOOKAT:=xlWhole, SEARCHORDER:=xlByRows, MatchCase:=True)

Would the quick fix be to just explicitly tell it to search top down?

Aflatoon
06-26-2017, 07:42 AM
Yes, it would. Find remembers any settings that were made in previous Find operations, including manual ones, so I would suspect that coworker #2 has run a find going upwards.