How do I hide rows in a range with a zero total?

[Twes]

In other words I have a range of rows (a23:s58) with data across columns and each row has a column (col s) with a total.

For the rows with a total of zero I'd like to hide that row.

Any help would be appreciated.

Twes

[Richie(UK)]

Hi Twes,

Welcome to the board :D

How about Data / Filter / AutoFilter and then select the Custom option from the drop down filter list and 'does not equal' and '0'.

HTH

[Twes]

Thank you.

That is very helpful.

Twes

[Julica]

I have a macro that does it for me:

Sub HideZeroRows()
    Application.ScreenUpdating = False 'turn off screen updating

    Selection.EntireRow.Hidden = False
    Set wrkRange = Selection
    For Each rw In wrkRange.Rows
        If Application.Sum(rw) = 0 Then
            rw.EntireRow.Hidden = True
        End If
    Next
    Application.ScreenUpdating = True 'refresh the screen

End Sub

You just highlight the selection you want to hide the rows in and run the macro. I have it in my Personal.xls file and attached to a toolbar button so I can use it any time I need it.