Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Use the "Group" method, row by row, or a entire range
for (int i = upperRowNumber; i <= lowerRowNumber; i++) { cellA = savedWorksheet.get_Range(string.Format("{0}{1}", ACellName, i), Missing.Value); cellB = savedWorksheet.get_Range(string.Format("{0}{1}", BCellName, i), Missing.Value); if (cellA.Value2 == null) { if (cellB.Value2 != null) (savedWorksheet.Rows[i, Missing.Value] as Range). Group(Missing.Value, Missing.Value, Missing.Value, Missing.Value); } } |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Expand Collapse Buttons | Excel Discussion (Misc queries) | |||
Protect worksheet but expand and collapse outline? | Excel Discussion (Misc queries) | |||
Programming Outlines (expand/collapse rows) in Excel | Excel Programming | |||
Outline, expand or collapse via VBA | Excel Programming | |||
Expand and Collapse Columns | New Users to Excel |