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?
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?