View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JMB
 
Posts: n/a
Default 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?