runtime error '13' type mismatch

Hi there!

I'm using the following code:

Dim rows As Integer
rows = Sheets("sheet3").UsedRange.rows.Count
For i = 2 To rows
    If Cells(i, 44).value = "#VALUE!" Then
        Cells(i, 44).ClearContents
    End If
Next i

There is a formula in the cell already, but I guess since it shows up false, it sets it as "#VALUE!"

Any help is appreciated! THANKS!!