How to: Clear Groups in Worksheets

Applies to
The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office. Project type Document-level projects Application-level projects Microsoft Office version Excel 2003 Excel 2007 For more information, see Features Available by Application and Project Type.

If you have groups of NamedRange controls or native Excel range objects in a worksheet, you can ungroup them..

Clearing Groups of NamedRange Controls

The following code example assumes you have three previously grouped Microsoft.Office.Tools.Excel.NamedRange controls in a worksheet: data2001, data2002, and dataAll.

To clear groups of NamedRange controls in a worksheet

• Call the Ungroup method. This code must be placed in a sheet class, not in the ThisWorkbook class.

  With Me
      .data2001.Ungroup()
      .data2002.Ungroup()
      .dataAll.Ungroup()
  End With
  

  this.data2001.Ungroup();
  this.data2002.Ungroup();
  this.dataAll.Ungroup();
  

Clearing Groups of Native Excel Ranges

This code example assumes you have programmatically added and grouped three native Excel ranges in the worksheet: data2001, data2002, and dataAll.

To clear groups of Excel ranges in a worksheet

• Call the Ungroup method.

  With Me.Application
      .Range("data2001").Ungroup()
      .Range("data2002").Ungroup()
      .Range("dataAll").Ungroup()
  End With
  

  this.Application.get_Range("data2001", missing).Ungroup();
  this.Application.get_Range("data2002", missing).Ungroup();
  this.Application.get_Range("dataAll", missing).Ungroup();
  

See Also

Tasks

How to: Create Groups in Worksheets

Concepts

Working with Worksheets

NamedRange Control

The Variable missing and Optional Parameters in Office Solutions