| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding/Exposing Rows based on a cell value
hi.
I need help writing a macro that will hide and unhide rows based on the value in Cell A1. In the below example, If Cell A1=100, rows 3 and 4 would be hidden and rows 1,2 and 5 would be unhidden. If cell A1=200 then only row 3 would be shown. Thanks in advance for your help, Tami Column B Row 1 100 Row 2 100 Row 3 200 Row 4 300 Row 5 100 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding rows based on a cell? | Excel Worksheet Functions | |||
| hiding or showing rows based on a cell value | Excel Discussion (Misc queries) | |||
| Hiding rows based value of cell within row | Excel Discussion (Misc queries) | |||
| hiding rows based on cell contents | Excel Discussion (Misc queries) | |||
| Hiding/Exposing Worksheets based on a Number Entry | Excel Discussion (Misc queries) | |||
Threaded Mode
