Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to hide rows based on a zero value in a particular cell
How complicated is it to create a macro to hide rows
conditioned upon a zero value in a particular column of that row? Could a second condition also be added to test for bold font type zeros to not be hidden? I have a VERY large cost estimating spreadsheet with 2,000 rows of items, and want to be able to hide rows that do not apply. Summary rows are in bold type and I would like to retain them, but hide all the detail. It takes forever manually!. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Hide rows based on value of column F | Excel Discussion (Misc queries) | |||
hide rows based on cell value | New Users to Excel | |||
hide rows based on value in cell | Excel Discussion (Misc queries) | |||
How to Hide Rows based on conditional value in cell | Excel Programming | |||
macro to hide rows based on formula? | Excel Programming |