How to Hide Rows that are blank but still have formulas

[DaBestEva]

Is there any way to select all rows that are blank, but contain formulas in a given range. For example, rows 5-10 don't have any displayed values, but all the cells have formulas, is there any way to select them all. I am trying to record a macro to hide all the cells with that characteristic

[Aardigspook]

Instead of hiding them, would you be happy to just filter them out?

Apply a filter to your heading row (I assume you have a heading row - if not, then you'll need to create one) by clicking the 'Filter' button in the 'Sort & Filter' section on the 'Data' tab of the ribbon.
You'll see drop-down arrows appear in each cell of the header row.
Click one of them and de-select 'Blanks' then click OK.


Alternatively, if you don't want to use the filter, try this macro:

Sub Hide_me()
Dim LastRow As Long, x As Long
LastRow = Cells(Cells.Rows.Count, "A").End(xlUp).Row
For x = LastRow To 1 Step -1
    If Cells(x, 1).Value = "" Then
        Rows(x).Hidden = True
    End If
Next
End Sub

It's from this Microsoft Community page:
https://answers.microsoft.com/en-us/...9-a25ecc908737

Note that it uses Column A as the check column - if your data doesn't use col A, then change the "A" to another appropriate column letter.