Error Finding Match When There Is Indeed A Match

[Ark68]

I have run into a problem which likely has a very easy solution, but I just can't seem to figure it out.

Consider these couple of lines of code from a larger module ...

    crid = ws_master.Cells(tmrow, 1)
    cdrow = Application.WorksheetFunction.Match(crid, ws_cd.Columns(1), 0)

crid = "44779003" - this is correct
However, when I try to get the value of cdrow, the line in red leaves me with an "Unable to get the Match property of the WorksheetFunction class" error.
The value 44779003 does truly exist in workbook ws_cd at cell A4 as a number. I'm not sure why the error.

 

[RoryA]

Pretty much guaranteed that either one is stored as a number (will default to right alignment in the cell) and the other as text (left-aligned by default), or your variable type is wrong (eg a String).

 

[Ark68]

Thanks Rory ... the error was in my declarations.