Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello everyone ... I'm a real newbie. So please take nothing for granted.
Working in Excell 2007 (Wanting 97-2003 Compatible mode). What I want to do is based on a cell (containing a formula) within each group of lines and that is to hide that specific group of lines if the formula equates to TRUE. Also, I would like to un-hide all rows afterwards. These functions could be linked to two button controls (on the same worksheet). Worksheet name = Exhibit1 There is 142 groups of 4 lines (consisting of 20 columns). The top left cell of each group (A?) is a cell with a formula resulting in TRUE (=0) or FALSE (<0) [based on one cell located in the 3rd line eg: "=IF(R28=0,TRUE,FALSE)"] Not sure where to start or where to put the code. Please help ... any suggestions or solutions would be very much appreciated. Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hide Rows If Condition True | Excel Worksheet Functions | |||
How do i hide rows if a condition is met | Excel Programming | |||
hide rows where cell condition is not met | Excel Worksheet Functions | |||
Hide rows based on a condition | Excel Programming | |||
Hide Rows meeting condition Amendment | Excel Programming |