Hide the line when cell B is empty

[Christine]

I would be grateful if someone could provide me with code that will hide a
line when a particular cell (e.g. B) is empty.

 

[Don Guillett]

Sub hiderowifcolempty()
For i = Cells(Rows.Count, "b").End(xlUp).Row To 1 Step -1
If Len(Application.Trim(Cells(i, "b"))) < 1 Then _
Rows(i).Hidden = True
Next i
End Sub

 

[Christine]

That works nicely. Could you tell me how to specify to hide only rows 5 to
10 when cell b is empty?

 

[Tom Hutchins]

You just need to change one line (the For statement):

Sub hiderowifcolempty()
For i = 10 To 5 Step -1
If Len(Application.Trim(Cells(i, "B"))) < 1 Then _
Rows(i).Hidden = True
Next i
End Sub

Hope this helps,

Hutch

 

[Christine]

Thank you both, Don and Tom.

You just need to change one line (the For statement):

Sub hiderowifcolempty()
For i = 10 To 5 Step -1
If Len(Application.Trim(Cells(i, "B"))) < 1 Then _
Rows(i).Hidden = True
Next i
End Sub

Hope this helps,

Hutch