benong
09-21-2010, 07:17 PM
hi,
if i use this formulae, it will search the column A downwards to find the itemCode.
matchItem = Application.Match(itemCode, Worksheets(1).Range("A:A"), False)
How can i do it in the reverse order?
I want to search the column A in the backwards order to match the itemCode.
eg.
column A contains many duplicates of itemCode.
Start from A100 to A1, find the first matched itemCode.
Pls advice.
if i use this formulae, it will search the column A downwards to find the itemCode.
matchItem = Application.Match(itemCode, Worksheets(1).Range("A:A"), False)
How can i do it in the reverse order?
I want to search the column A in the backwards order to match the itemCode.
eg.
column A contains many duplicates of itemCode.
Start from A100 to A1, find the first matched itemCode.
Pls advice.