Hide the line when cell B is empty

  • Thread starter Thread starter Christine
  • Start date Start date
C

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.
 
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
 
That works nicely. Could you tell me how to specify to hide only rows 5 to
10 when cell b is empty?
 
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
 
Thank you both, Don and Tom.

Tom Hutchins said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Write a macro that hides rows based on empty cells 3
hide products without pricing 6
Trying to run excel vba code when cell value changes from empty to entered value. 1
Macro to hide/show rows and columns 4
first empty value 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Hiding rows or columns based on cell contents 3
Set chart series endpoint dynamically 0

Back
Top