hide rows If a cell value is zero.

**Benb** · 12-23-2008, 08:05 AM

Hi,
I'm a beginner and need some help....

How would I write a macro to hide a range of rows If a cell value is zero, then do the same for five additional ranges of rows?

In my words:
If AT214=0, hide rows 214 to 244
and
If AT245=0, hide rows 245 to 278
and
If AT279=0, hide rows 279 to 311
and
If AT312=0, hide rows 312 to 344
and
If AT345=0, hide rows 345 to 377
and
If AT378=0, hide rows 378 to 410

Any help to put me on the right path would be greatly appreciated!
Ben

Brisbane Austraila

**JBeaucaire** · 12-23-2008, 08:17 AM

Put this macro into a Module on your sheet.

Sub ZeroTest()
    If Range("AT214").Value = 0 Then
    Rows("214:244").EntireRow.Hidden = True
    Else
    End If
    
    If Range("AT245").Value = 0 Then
    Rows("245:278").EntireRow.Hidden = True
    Else
    End If
    
    If Range("AT279").Value = 0 Then
    Rows("279:311").EntireRow.Hidden = True
    Else
    End If
    
    If Range("AT312").Value = 0 Then
    Rows("312:344").EntireRow.Hidden = True
    Else
    End If

    If Range("AT345").Value = 0 Then
    Rows("345:377").EntireRow.Hidden = True
    Else
    End If

    If Range("AT378").Value = 0 Then
    Rows("378:410").EntireRow.Hidden = True
    Else
    End If
End Sub

**davesexcel** · 12-23-2008, 08:26 AM

Originally Posted by JBeaucaire

Put this macro into a Module on your sheet.....
[

Hi JBeaucaire,
Are you sure you want this code in a Sheet Module?

**JBeaucaire** · 12-23-2008, 08:29 AM

Hehe, funny how little words trip me up. I just meant to say Module1. It works on Sheet1, but just not where I normally put standard macros.

Module1.

**Benb** · 12-23-2008, 08:54 AM

Thank you! thank you! thank you!

It worked a treat =

**adamsjc** · 08-26-2011, 09:56 AM

I just stumbled upon this. I have the same issue, except I have cells that are linked to option buttons. I have 24 rows; when the first option button is pressed, only 8 rows have information in them, the others have zeros and I want them hidden. But when the second option button is pressed, now 16 rows have information, the others have zeros. Etc Etc. (5 buttons total) This code works for the first option button that I happen to press, but if i click another, it will not register the number of rows that might contain 0s now. How can I fix this?

Many thanks.

**JBeaucaire** · 08-26-2011, 10:57 AM

By reading the FORUM RULES (link above in the menu bar) and starting your own thread, attach your sample workbook and ask your specific questions there.

If you find other threads, like this one, to be relevant, include a link to this thread in your own thread.

Thanks, and welcome to the forum!