Type Mismatch Error

[Ark68]

I am receiving a "Type mismatch" error with this line of code (in red), and I am looking for some guidance as to it's cause. The line is intended to return the line number holding the value (usd) in column B of worksheet ws_dest.

        With ws_dest
            drow = Application.WorksheetFunction.index(usd, .Range("B:B"), 0)
        End With

drow is defined as long.
usd is a variable holding a serial date
ws_dest is a legit worksheet
The values in column B are dates(?) formatted as ddd dd-mmm. When I click on a cell in column B, the formula bar displays 1/23/2018 (as an example), so assume it is also a date.

 

[jproffer]

Without recreating your workbook, a couple ideas that come to mind are:

Try adding a "." in front of "Application"

Try removing "Application" altogether (but leave the "." in front of WorksheetFunction)

 

[louisH]

Hi.

Try to use the match function

[COLOR=#ff0000]Application.WorksheetFunction.Match(usd, .Range("B:B"), 0)[/COLOR]

instead

 

[Ark68]

Thank you both for offering up your solutions.
It turns out, I was using the wrong command ... I wanted MATCH when I thought INDEX was what I needed.
louiseH, you set me on the proper course!