match property error

[cmccabe]

Unable to get the Match property of the WorksheetFunction Class, with the yellow line highlighted.

Please Login or Register  to view this content.

[/COLOR]

the headers in row 4 are:

Thank you .

[cmccabe]

Here is the full code:

Please Login or Register  to view this content.

I tried changing the With Application and Dim Classification As String and get a type mismatch error with the same line in blue highlighted. Thanks.

[Norie]

Why aren't you using the 3rd argument of Match?

Also, have you checked for trailing/leading spaces in the header(s) on the sheet?

[cmccabe]

There are no leading or trailing spaces.

Initially, I had:

Please Login or Register  to view this content.

, but The address of the range rData.Rows(4) is annovar!$A$4:$F$4 and I want a value in that entire row. Is that what you mean by 3rd argument? Thanks.

[Norie]

The 0 is the 3rd argument and you don't have it in the first code you posted.

Also, in that first code there's no sheet reference for Rows(1) or Rows(4) so they will refer to the currently active sheet.

[cmccabe]

Thank you very much, it is working