Macro to hide rows containing #N/A

**arkharova.s** · 02-17-2014, 08:04 AM

Hi! need ur help, please!!

I have #N/A in B27:F36
i need a macro that will hide rows containing #N/A

plsss!!! thank u!!!!

**nilem** · 02-17-2014, 08:12 AM

Hi arkharova.s
try it

Sub test()
On Error Resume Next
Range("B27:F36").SpecialCells(xlCellTypeFormulas, xlErrors).EntireRow.Hidden = True
End Sub

**Olly** · 02-17-2014, 08:15 AM

Or to just hide NA errors:

Sub foo()
Dim c As Range
Application.ScreenUpdating = False
For Each c In Range("B27:F36")
    If WorksheetFunction.IsNA(c.Value) Then c.EntireRow.Hidden = True
Next c
Application.ScreenUpdating = True
End Sub

**JOHN H. DAVIS** · 02-17-2014, 08:29 AM

Duplicate post:

http://www.excelforum.com/excel-prog...ining-n-a.html

**arkharova.s** · 02-17-2014, 11:58 PM

Dears!! thank you!! both options are working - great! thanks a lot!!

Macro to hide rows containing #N/A

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Macro to hide rows containing #N/A

Re: Macro to hide rows containing #N/A

Re: Macro to hide rows containing #N/A

Re: Macro to hide rows containing #N/A

Re: Macro to hide rows containing #N/A

Thread Information

Users Browsing this Thread

Similar Threads

Need help creating macro to hide rows based upon whether 1 of 3 rows have data

Macro: Copy 3 Rows & Insert below with Format....Also hide last two rows inserted

[SOLVED] Macro to hide Zero Rows

Using check boxes to hide and un-hide rows with drop down lists within rows

Macro to Hide and Unhide Rows but still be able to insert rows

Bookmarks

Bookmarks

Posting Permissions