Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 13th 06, 08:39 PM posted to microsoft.public.excel.worksheet.functions
zhehol
 
Posts: n/a
Default 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   Report Post  
Old June 14th 06, 03:43 AM 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide Rows - copy and paste only rows that show Access101 Excel Worksheet Functions 3 March 1st 06 01:39 AM
hide rows based on cell value dummster New Users to Excel 1 February 16th 06 12:37 AM
automatically hide rows with zero value hfc21 Excel Worksheet Functions 1 January 23rd 06 08:33 PM
Deleting Rows Automatically using a Text File List mirdonamy Excel Discussion (Misc queries) 9 January 12th 06 12:11 AM
Excel - if cells = 0, how to conditionally hide rows in chart fineimage Excel Worksheet Functions 1 November 11th 04 10:45 PM


All times are GMT +1. The time now is 11:12 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017