Application.match error

[exceluser90]

I'm trying to find the row which a particular date is in on another sheet

Dim f, i, dnum As Integer
Dim hst, hfin, fst, ffin As Date
hst = ActiveSheet.Cells(3, 4).Value
dnum = Application.Match(hst, Sheets(pow).Range("A1").EntireColumn)

I get a type mismatch error, but I'm not sure why. Any thoughts? The column that the range refers to is all formatted as dates as well.

 

[VoG]

Maybe

Dim f As Integer, i As Integer, dnum As Integer
Dim hst As Date, hfin As Date, fst As Date, ffin As Date
hst = ActiveSheet.Cells(3, 4).Value
dnum = Application.Match(hst, Sheets("pow").Columns("A"), 0)