Run-time error 1004: Unable to get the Match property of the WorksheetFunction class

[maffmommie]

So I created this code for some dummy data and it worked seamlessly. Now that I've copied it to the real workbook I get an run-time error.

I've looked at prior threads that have solved this problem and it doesn't seem to work for me.

Could you help me out?

Please Login or Register  to view this content.

[Andrew-R]

You're getting the run-time error because it can't find the value you're searching for, either:

1. Double-check your ranges and values, to make sure you're looking for the right thing in the right place OR

2. Put some error trapping in to deal with this OR

3. Switch to using .FIND, which returns more manageable exceptions.

[maffmommie]

Well the value is definitely in the range...hmmm...

How would I change it to .FIND? I just need to look in the header row on 1 particular sheet and match it with the header row of the another sheets

[Andrew-R]

Is it in the range after you account for shifting the whole range one column right?

Also you might want to specify somewhere in your code which workbook and sheet you're working with, as this may resolve some ambiguity.