How to hide #N/A error values

[Sean15]

I have a worksheet with several #N/A error values. How can I hide rows that contain the #N/A errors. Thank you for your help.

Sean

 

[texasalynn]

you can change the formula that causes the error or perhaps create a conditional format that you make it formulais
=ISNA(K5)
format with font color white
change the cell reference to your cell

 

[Asator]

=if(isna(your_formula),"",your_formula)

 

[Sean15]

Thank you, but changing cell format leaves too many white cells, and changing cell reference would not be feasible. It's best to just hide the entire row for every #N/A value in column B. Is that possible?

Sean

 

[texasalynn]

you could create a filter for the #N/A, then select the #N/A and hide row

otherwise you would need some VB

 

[Sean15]

could someone post VB codes? I have zero knowledge of VB.


Sean

 

[Sean15]

The code below hides rows with zero values (got coded from internet). How can I make the code unhide hidden rows. Thanks your help.


Sub HideRows()

Dim c
Application.ScreenUpdating = False

With Worksheets("INCOME STATEMENT").Range("b6:b752")
.EntireRow.Hidden = False
End With

For Each c In Worksheets("INCOME STATEMENT").Range("b6:b752")
If c.Value = 0 Then

c.EntireRow.Hidden = True
End If
Next c

ActiveSheet.DisplayAutomaticPageBreaks = False
Application.ScreenUpdating = True


End Sub

 

[texasalynn]

this part unhides the rows

With ActiveSheet.Range("b6:b752")
       .EntireRow.Hidden = False
End With

 

[Jonmo1]

You don't need VBA, as texaslynn said, you can use the autofilter.
when you click the filter dropdown, choose custom - does not equal - #N/A