Hiding Row if a certain cell in that row is blank

[ardykav]

Hi All,
I have a large budget spreadsheet where i have various codes ranging from A1-A50, however right now I only use about 15 of the codes but the other ones will be eventually populated. The description column uses an index match Formula which looks up a code list. What i want to do is hide any Rows where no value is returned in the Description column. I have tried some code on other forums but it appears that because I have a formula in the description column it doesnt recognise it as blank. This is the formula I use for description =IFERROR(INDEX(tb_Master_table[Sub Category],MATCH(A22,tb_Master_table<sub>,0)),"")

So the idea would be that only rows from "code to A4" would be visible. All help greatly appreciated [TABLE="width: 366"]
<tbody>[TR]
[TD="class: xl70, width: 366"] [/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Code[/TD]
[TD]Description[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]Accountant Fees[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]Legal Fees[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]Rent[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]Fixtures and fittings[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A7[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A8[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A9[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A10[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A11[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A12[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A13[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A14[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]</sub>

 

[Martvg]

Hi,

I believe this is the code you are looking for:

Sub Macro2()    Dim x As Integer
    Dim y As Integer
    
    y = 50
    
    For x = 1 To y
    
    If Cells(x, 1).Value = "" Then
    
    Rows(x).EntireRow.Hidden = True


    End If
    
    Next x
    
End Sub

Best Regards,
Mart

 

[ardykav]

Thanks Mart, so i want any row with a "" value in column B to be hidden, however when i run this code it doesnt hide the rows in the column that have a formula in it? even though the results of the formulas return a "" value