Search function worked once perfectly but won't work again. Unable to get the match property of the worksheetfunction class Error.

[dellehurley]

Hi
I have created a userform with a search function. it worked perfectly but now has in issue with this line of code. Error code 2004. Unable to get the match property of the worksheetfunction class.

 iColumn = Application.WorksheetFunction.Match(sColumn, Dbws.Range("A1:L1"), 0)

Link to Userform

Can anyone help?
Dannielle

 

[dellehurley]

Hi
I have created a userform with a search function. it worked perfectly but now has in issue with this line of code. Error code 2004. Unable to get the match property of the worksheetfunction class.

 iColumn = Application.WorksheetFunction.Match(sColumn, Dbws.Range("A1:L1"), 0)

Link to Userform

Can anyone help?
Dannielle

I did not realise Google drive would force you to use Google Documents. Here is another link via Dropbox.
Dropbox Link to File

 

[dellehurley]

I did not realise Google drive would force you to use Google Documents. Here is another link via Dropbox.
Dropbox Link to File

I sorted out the error. The header was overridden and this caused the error.