Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Row/s (single/grouped) based on cell value of column in the r
Any ideas how we could;
Starting from a row (say 10) and for each subsequent row, to last row of used range; If cell value in column C of the row = 0, then hide the row (if not already hidden). If cell value in column C of the row 0, then unhide the row (if hidden). To make it more interesting; Only read the first row of any row grouping and hide/unhide all the rows in that group, based on the condition of the first row. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to hide and show a grouped column via VBA code? | Excel Discussion (Misc queries) | |||
sum column based on single cell match? | Excel Worksheet Functions | |||
Can you hide the value contained in a single cell | Excel Discussion (Misc queries) | |||
Hide column or row based on a cell in the column or row? | Excel Discussion (Misc queries) | |||
Hide/Unhide column based on cell value | Excel Programming |