T
titus
I have the following code :
If IsError(Application.WorksheetFunction.Match(cells(x, 1),
Worksheets("Sheet1").Range("A2:A15"), 0)) Then
do this
else
do that
The code works fine when there is a match ( for every cell in column A
of worksheet 2 it finds a match with the range A2:A15 in worksheet 1),
but I get the error 'unable to get match property of WorksheetFunction
class' when there is no match found i.e it gives a #N/A error. I dont
know what this error means. Any ideas ? Thanks
titus
If IsError(Application.WorksheetFunction.Match(cells(x, 1),
Worksheets("Sheet1").Range("A2:A15"), 0)) Then
do this
else
do that
The code works fine when there is a match ( for every cell in column A
of worksheet 2 it finds a match with the range A2:A15 in worksheet 1),
but I get the error 'unable to get match property of WorksheetFunction
class' when there is no match found i.e it gives a #N/A error. I dont
know what this error means. Any ideas ? Thanks
titus