Decreases the outline level of rows in the specifed range.

[Visual Basic]
Sub Ungroup()
[C#]
void Ungroup();
[C++]
void Ungroup();
[JScript]
function Ungroup();

Example

This example ungroups three first rows on sheet one.

[C#]
 book.Worksheets[1].Range["A1:A3"].Ungroup();

[Visual Basic]
 book.Worksheets(1).Range("A1:A3").Ungroup()

[C++]
 book->Worksheets->Item[1]->Range->Item[S"A1:A3"]->Ungroup();

This example is the same as the previous.

[C#]
 book.Worksheets[1].Range["A1:A3"].Rows.Ungroup();

[Visual Basic]
 book.Worksheets(1).Range("A1:A3").Rows.Ungroup()

[C++]
 book->Worksheets->Item[1]->Range->Item[S"A1:A3"]->Rows->Ungroup();

This example ungroups three first columns on sheet one.

[C#]
 book.Worksheets[1].Range["A1:C1"].Columns.Ungroup();

[Visual Basic]
 book.Worksheets(1).Range("A1:C1").Columns.Ungroup()

[C++]
 book->Worksheets->Item[1]->Range->Item[S"A1:C1"]->Columns->Ungroup();

See Also

IRange Interface | NativeExcel Namespace | IRangeColumns.Ungroup Method | Group Method | OutlineLevel Property | IRangeColumns.OutlineLevel Property | ClearOutline Method

---