Problem With "Match" of Dates

[Ark68]

With ws_staffrec
        sdate = .Range("AF6").Value
        refrow = Application.WorksheetFunction.Match(sdate, ws_master.Columns(1), 0)

The line in red is giving me an "Unable to get the Match property of the WorksheetFunction class." error.

The value of sdate [ws_staffrec.range("AF6")] = 2020-04-09 (sdate is declared date)
A value of 2020-04-09 exists in ws_master, column 1 at cell A116.

Is anyone able to advise why my match is failing? I know working with dates can sometimes be awkward.

 

[steve the fish]

I usually turn the date to an integer and look for that eg CLng(sdate) rather than sdate

 

[jasonb75]

See if this works

With ws_staffrec
    sdate = CDate(.Range("AF6").Value)
    Set refcell = ws_master.Columns(1).Find(sdate)
    If Not refcell Is Nothing 
        Then refrow = refcell.Row

This should also catch any errors if the date is not found

 

[Ark68]

Thank you Steve the Fish, you solution provided the results I was looking for. Jason, thank you as well. I haven't had an opportunity to test your solution, but I anticipate an opportunity further into my code. I like the fact that it would catch any errors resulting for the date not being available.

I appreciate all your help folks.