Unable to get Match property of the WorksheetFunction class

hi ..

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

In my macro im using

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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.

The MATCH function alwats protests when it does not find the match, even when when used as a function in a cell. But in VBA you also have to code around that result and deal with it.

The simplest is to put On Error Resume Next above it so the code will proceed and default to a value of zero when no match is found.

Please Login or Register  to view this content.

So, if you're trying to determine which sheet in the workbook has the "Design Step" column and then mark that worksheet to be used, something like:

Please Login or Register  to view this content.