Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I automatically hide or suppress zero balance rows
I want to format my spreadsheet so that when an if/then formula returns a
zero balance, the entire row is hidden or suppressed. Can this be done in Excel? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I automatically hide or suppress zero balance rows
Right click on your sheet tab and paste this code into the code module. It
assumes the cell containing the If statement is named "MyCell". You can change the name as you wish, but I would recommend naming it. Private Sub Worksheet_Calculate() With Me.Range("MyCell") .EntireRow.Hidden = CBool(Evaluate(.Value = 0)) End With End Sub "zhehol" wrote: I want to format my spreadsheet so that when an if/then formula returns a zero balance, the entire row is hidden or suppressed. Can this be done in Excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Rows - copy and paste only rows that show | Excel Worksheet Functions | |||
hide rows based on cell value | New Users to Excel | |||
automatically hide rows with zero value | Excel Worksheet Functions | |||
Deleting Rows Automatically using a Text File List | Excel Discussion (Misc queries) | |||
Excel - if cells = 0, how to conditionally hide rows in chart | Excel Worksheet Functions |