Applies To
Chart Object, DialogSheet Object, Worksheet Object.
Description
Accessor. Returns an object that represents a single group (a GroupObject object, Syntax 1) or a collection of all the groups (a GroupObjects object, Syntax 2) on the sheet.
Syntax 1
object.GroupObjects(index)
Syntax
object.GroupObjects
object
Required. The Chart, DialogSheet or Worksheet object.
index
Required for Syntax 1. The name or number of the group (can be an array to specify more than one).
Example
This example ungroups the graphic objects in group one on Sheet1.
Worksheets("Sheet1").GroupObjects(1).Ungroup