Match6_Until

Searches for six values in six columns and return the row number if all found, with ability to stop at certain row for performance reasons
Just like Match6 but with a stop once you pass StopAtRow, it will stop searching after that row, to return faster than Match6.
As usual, you may pass worksheet, workbook and starting row, or not

CodeFunctionName What is this?

Public

Tested

Original Work

Access is limited.

Login here using your Linkedin account. to see or download code.

No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydevlib.com

Linkedin Login

Val1, Col1, Val2, Col2, Val3, Col3, Val4, Col4, Val5, Col5, Val6, Col6, Optional Wb = "This", Optional Shee = "Active", _
    Optional StartFromRow = 1, Optional StopAtRow = 99999

Views 1

Downloads 0

CodeID
DB ID