Hi,
Is there a way to turn on or off a group of rows based on a cell value. For example I have row a10 to a20 grouped "Data/(Outline section)/Group", which gives the plus or minus sign depending if the rows are suppressed or not. What I'm looking for a some vba code where I can name a group and either show/hide the rows in the group based on the contents of a cell. For example =if(A1 = "bob", bobgroup = false, bobgroup = true).
Is there a way to turn on or off a group of rows based on a cell value. For example I have row a10 to a20 grouped "Data/(Outline section)/Group", which gives the plus or minus sign depending if the rows are suppressed or not. What I'm looking for a some vba code where I can name a group and either show/hide the rows in the group based on the contents of a cell. For example =if(A1 = "bob", bobgroup = false, bobgroup = true).