Hello,
Long time lurker, first time poster
I'm trying to use MATCH to locate some items in a second sheet (and eventually a second workbook), however I'm running across some issues when attempting to use the following code.
This is part of a for loop, y is actually the variable in the loop, so it's increasing each iteration. I'm basically assigning the variable v the result so I can use it later on to write some values to another cell.
The bold, underlined, italicized portion is the area I'm having a problem with. I'm trying to search the second worksheet for something that is listed on the first worksheet. This is actually part of a loop so it will be going through a column on the first sheet and then searching for the same text on the second sheet. The reason I'm using match is because I need coordinates (partial, or otherwise) for the location of the cell that contains the match.
Also, as I said the next part of this is going to be to implement it to search a closed, external document. So if any helpful soul out there could lend a hand on either part it would be greatly appreciated.
-T
Long time lurker, first time poster
I'm trying to use MATCH to locate some items in a second sheet (and eventually a second workbook), however I'm running across some issues when attempting to use the following code.
Code:
v = Application.WorksheetFunction.Match(Sheet2.Cells(y + 3, 2), [I][B][U]Sheets("sheetname").Range("A1:A20")[/U][/B][/I], 0)This is part of a for loop, y is actually the variable in the loop, so it's increasing each iteration. I'm basically assigning the variable v the result so I can use it later on to write some values to another cell.
The bold, underlined, italicized portion is the area I'm having a problem with. I'm trying to search the second worksheet for something that is listed on the first worksheet. This is actually part of a loop so it will be going through a column on the first sheet and then searching for the same text on the second sheet. The reason I'm using match is because I need coordinates (partial, or otherwise) for the location of the cell that contains the match.
Also, as I said the next part of this is going to be to implement it to search a closed, external document. So if any helpful soul out there could lend a hand on either part it would be greatly appreciated.
-T
