Find A Record In Another Sheet With VBA Code

Hi All;

I'm trying to find a specific text in another sheet by using the code below. But it gives me "Type Mismatch" error. Being a beginner on Excel VBA coding, I couldn't figure it out. Any help will be appreciated.

Sub mdf()
Dim cst As Variant
Dim mycell As Range, lkrng As Range

Set cst = ActiveSheet.Range("H4").Value
Sheets("LIST").Activate
Set lkrnd = Sheets("LIST").Range("C3")
Set lkrng = Range(lkrng, lkrng.End(xlDown))
With cst
For Each mycell In lkrng
If mycell.Value = cst Then
mycell.Select: Exit Sub
End If
Next mycell
End With
End Sub

Thanks