Iserror function

[angeld27]

Hi All,

Could you please help on below?

I want to perform some operation in case of below situation

If IsError(WorksheetFunction.Match(TDAppName.Text, Worksheets("SHEET1").Range("B1:B6333"), 0)) Then

PERFORM ACTIVITY 1

ELSE

PERFORM ACTIVITY 2

But getting error message " Unable to get match property of WORKSHEETFUNCTION CLASS"

 

[VoG]

Try changing Worksheet.Function to Application

 

[angeld27]

Thanks Peter....issue has resolved now