hi ..
I have written a macro to find out the particular colomn name.
In my macro im using
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
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.
Bookmarks