Code to hide rows

[dpaton05]

I need some code to hide some rows if some cells are blank.

• If C13 is blank, I need to hide row 25
• if C14 is blank I need to hide row 26
• If C15 is blank I need to hide row 27
• If C16 is blank, I need to hide row 28

Can someone help me with the code please?

 

[dpaton05]

The cells are truly blank, there are no values, formulas or anything in them. That code you provided does the same thing.

 

[Michael M]

Hmm, interesting, as both codes work fine for me !!
It's not imported data is it ??

 

[dpaton05]

What do you mean by that?

 

[dpaton05]

Would it matter that there is additional info in separate columns in the same row?

 

[dpaton05]

Not sure what happened but I tried the code in post #5 again and it worked perfectly. Thanks Mike.

Just wondering if you could help me adjust the code so that for each row, 13-16, they are hidden if the corresponding cell in column C is blank please?

 

[Michael M]

Try

Sub MM1()
Dim cell As Range, n As Long
n = 25
  For Each cell In Range("C13:C16")
    If cell.Value = "" Then
        Rows(cell.Row).Hidden = True
        Rows(n).Hidden = True
        n = n + 1
    End If
  Next cell
End Sub

 

[dpaton05]

Thanks Michael, that works but my supervisor tells me he wants something else.

This code works, I just need to know how to combine it.

Private Sub CommandButton1_Click()


Dim cell As Range, n As Long
n = 24


  For Each cell In Range("C13:C16")
    If cell.Value = "" Then Rows(n).Hidden = True
    n = n + 1
  Next cell
 
   If Range("C16") = "" Then
        Rows(28).Hidden = True
    End If
    
End Sub

 

[Michael M]

What do you mean by combine it ??

 

[dpaton05]

Actually, the code doesn't work. If I have nothing in the cells (C13:C16) it will hide the empty cells from the total rows but if there is something in C13:C16, it will not hide all of the total rows that have a 0 in them.

 

[Michael M]

if there is something in C13:C16, it will not hide all of the total rows that have a 0 in them.
The original request was to Hide rows if the CELLS WERE BLANK !!!