Hide an entire row if cell in column A is not blank

superiorsvc · Feb 4th 2015

If Column A is not blank for that row - then I want to hide that entire row. Would like VBA code to do this for the whole sheet again. Range rows 1-36855.

**S O** · Feb 4th 2015

Re: Hide an entire row if cell in column A is not blank

That's nice. Did you have a question? :grin:

jolivanes · Feb 5th 2015

Re: Hide an entire row if cell in column A is not blank

Like this?

Code

Sub Maybe()
With Range("A1:A" & Cells(Rows.Count, 1).End(xlUp).Row)
    .SpecialCells(2).EntireRow.Hidden = True
End With
End Sub

NoSparks · Feb 5th 2015

Re: Hide an entire row if cell in column A is not blank

I kinda liked #4 on the other forum.

Hide an entire row if cell in column A is not blank

Participate now!

Share