| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding rows in a range based on TRUE/FALSE value in each row
Sheet name: "Education"
Reference Range: A1:A100 I need to hide every entire row in that range if the value in that row is FALSE. The user will have a checkbox linked to the cells in that range, and if the box is not checked, the value will be FALSE. In other words, if the value of A16 is FALSE, that row would be hidden, and so forth. I've tried to apply many solutions I've found and none seem to do exactly that Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| Trying to select a specific range based on the time value of user form input | New Users to Excel | |||
| range inside RANK formula based on contents of other cells | Excel Worksheet Functions | |||
| print area selection slows excel, formula for hiding rows?? | Excel Discussion (Misc queries) | |||
| Row Sequencing | Excel Worksheet Functions | |||
Threaded Mode
