Quote:
Originally Posted by gmaxey
Yes. Every record of the REF_SHEET that might have a match in the NDS_SHEET must be processed.
|
Well, in point 2 you have to throw away EXIT FOR to search further.
Quote:
3. Are we looking for "File Name" from column H of sheet NDS_SHEET in column B of sheet REF_SHEET. Yes.
|
Just Yes/No, no explanation needed. Now we need to make changes.
1. Change to
Code:
ReDim result(1 To UBound(find_data, 1), 1 To 9)
2. Delete "Exit For"
That's all