Hide Row Based on Error in Cell--Excel 2010

[LadyNatira]

I would like to hide entire rows if there is a #NUM! error in a specific column--column U in this case. I've tried this:

Sub Macro1()
Columns("U").SpecialCells(xlCellTypeFormulas, 16).EntireRow.Hidden
End Sub

. . . for which I get a Hidden method of Range class failed error.

Any suggestions?

[Mumps1]

Try:

Columns("U").SpecialCells(xlConstants, xlErrors).EntireRow.hidden=true

[LadyNatira]

Try:

Columns("U").SpecialCells(xlConstants, xlErrors).EntireRow.hidden=true

No cells found on this one, but thanks for the suggestion!

[walruseggman]

How about something like this?

Sub Natira()
Set CheckRange = Range("U1:U" & Cells(Rows.Count, "U").End(xlUp).Row)

For Each Cell In CheckRange
If Cell.Text = "#NUM!" Then
    Cell.EntireRow.Hidden = True
End If
Next
End Sub

[LadyNatira]

How about something like this?

Sub Natira()
Set CheckRange = Range("U1:U" & Cells(Rows.Count, "U").End(xlUp).Row)

For Each Cell In CheckRange
If Cell.Text = "#NUM!" Then
    Cell.EntireRow.Hidden = True
End If
Next
End Sub

This one worked like a charm!

Yipee and thank you so much!