| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
collapse an expand rows using VB
I want to collapse and expand certain rows in a worksheet. The rows that
should be collapsed (height=0) or expanded (height=17) are determined by the value of a certain cell in this row. In this case it is the value of the cell in the C-column that will termine whether or not the row height should be set to 0 or 17. If the cell value is "100", the height should be set to 0, and if the cell value is different from 100 the height should be set to 17. I am a bit lost here. Can anyone help me with this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i expand and collapse rows | New Users to Excel | |||
| Expand/Collapse Buttons for hidden rows or colums | Excel Discussion (Misc queries) | |||
| How do I move the expand/collapse for rows and columns in Excel? | Excel Worksheet Functions | |||
| Programming Outlines (expand/collapse rows) in Excel | Excel Programming | |||
| Expand/Collapse Rows | Excel Worksheet Functions | |||
Threaded Mode
