UnGroup method
Promotes a range in an
outline (that is, decreases its
outline level).
Syntax
procedure UnGroup(Rows: boolean = true);
| Rows |
Boolean (Optional). True to ungroup rows; False to ungroup columns. Default value is True |
Example
This example ungroups three first rows on sheet one.
Workbook.Sheets[1].Range['A1', 'A3'].UnGroup;
This example is the same to previous.
Workbook.Sheets[1].Range['A1', 'A3'].UnGroup(True);
This example is the same to previous.
Workbook.Sheets[1].Range['A1', 'A3'].Rows.UnGroup;
This example is the same to previous.
Workbook.Sheets[1].Range['A1', 'A3'].Rows.UnGroup(True);
This example ungroups three first columns on sheet one.
Workbook.Sheets[1].Range['A1', 'C1'].UnGroup(False);
This example is the same to previous.
Workbook.Sheets[1].Range['A1', 'C1'].Columns.UnGroup;
This example is the same to previous.
Workbook.Sheets[1].Range['A1', 'C1'].Columns.UnGroup(False);
This example ungroups rows row1 through row2.
Workbook.Sheets[1].RCRange[row1, 1, row2, 1].UnGroup;
This example ungroups columns col1 through col2.
Workbook.Sheets[1].RCRange[1, col1, 1, col2].Columns.UnGroup;
See also