Hide empty cells with "" in them

CodingNewb · Dec 8th 2021

Cell has =+IF(A21<=$A$20,VLOOKUP(A21,Inputs!$N$17:$O$26,2,FALSE),"") in it; however, when the cell is false and turns out "", which is nothing in the cell, how do I hide/delete the rows?

Code

Sub Delete_Blank_Rows()


On Error Resume Next
With Range("B20:B29")
.Value = .Value
.SpecialCells(xlCellTypeBlanks).EntierRow.Delete
End With
End Sub

**Code 2 I tried**

Sub E_Hide_Rows()

    Worksheets("Zone Pricing").Select
    Range("$B$20:$B$29").AutoFilter 1, "<>", , , False
  

    Worksheets("Zone Pricing").Select
    Range("$I$34:$I$43").AutoFilter 1, "<>", , , False

End Sub

Display More

rollis13 · Dec 8th 2021

If you use On Error Resume Nextyou must be very carefull with your spelling.

Have you tried:

Code

.SpecialCells(xlCellTypeBlanks).EntireRow.Delete

instead of:

Code

.SpecialCells(xlCellTypeBlanks).EntierRow.Delete

**royUK** · Dec 9th 2021

What is not working?

You need the error handler in case there are no blank cells. Run the code without the error handler to see if any error messages are shown.

Hide empty cells with "" in them

Participate now!

Share