Skip to content

Latest commit

 

History

History
40 lines (22 loc) · 1.07 KB

Excel.ShapeRange.Group.md

File metadata and controls

40 lines (22 loc) · 1.07 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
ShapeRange.Group method (Excel)
vbaxl10.chm640086
vbaxl10.chm640086
Excel.ShapeRange.Group
f0ad9b81-42ad-0ee6-d2e2-ff2a88d47a97
05/14/2019
medium

ShapeRange.Group method (Excel)

Groups the shapes in the specified range.

Syntax

expression.Group

expression A variable that represents a ShapeRange object.

Return value

A Shape object that represents the grouped shape.

Remarks

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.

The Range object must be a single cell in the PivotTable field's data range. If you attempt to apply this method to more than one cell, it will fail (without displaying an error message).

[!includeSupport and feedback]