Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a financial summary and depending on the selections some rows are
always going to have $0 values. I need VBA code that will automatically run each time the worksheet recalculates that will hide a row with all $0 values in columns B through F. It affects a total of five rows and they all operate on different conditions, but the rule would apply to all of them if the sum of columns B through F for the row = $0. Any help would be appreciated. I am only starting to work with code and have never taken any courses so if you would not mind I would get a lot more out of it with a simple explanation of how it works or a reference to review it. Thank you in advance. Joe Frustrated in Baltimore |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Enabling option „Format rows“ to hide/unhide rows using VBA-code? | Excel Discussion (Misc queries) | |||
Macro to show/hide rows based on a range of dates | Excel Programming | |||
hide multiple rows based on condition within rows | Excel Programming | |||
Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells? | New Users to Excel | |||
Code to hide rows based on cell contents | Excel Programming |