Unable to get Match property of the WorksheetFunction class

[pavu]

hi ..

I have written a macro to find out the particular colomn name.

In my macro im using

Application.WorksheetFunction.Match("design step", ActiveWorkbook.Sheets(j).Range("1:1"),0)

to compare whether 'design step' is there in the first row.

When i executed this code, in some sheets its working fine but in some sheets its throwing error like 'Unable to get Match property of the WorksheetFunction class '. I tried changing the code to

Application.Match("design step", ActiveWorkbook.Sheets(j).Range("1:1"),0)

by removing 'WorksheetFunction'. When i execute the code, the previous error was gone but 'Type Mismatch' error is coming.

And also want to add code for error hanndling like if the string is not found go to the next tab in the same workbook.
Can anyone help me in this . Thanks in advance.