This documentation is archived and is not being maintained.

ShapeRange.Regroup Method 

Regroups the group that the specified shape range belonged to previously. Returns the regrouped shapes as a single Shape object.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in

Dim returnValue As Shape
Dim shapeRange1 As ShapeRange
returnValue = shapeRange1.Regroup()

Shape Regroup();
public Shape Regroup();
function Regroup() : Shape;

The Regroup method only restores the group for the first previously grouped shape it finds in the specified ShapeRange collection. Therefore, if the specified shape range contains shapes that previously belonged to different groups, only one of the groups will be restored.

Note that, because a group of shapes is treated as a single shape, grouping and ungrouping shapes changes the number of items in the Shapes collection and changes the index numbers of items that come after the affected items in the collection.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms