WORKGROUP

Macro Sheets Only

Equivalent to choosing the Group Edit command from the Options menu in Microsoft Excel version 4. Creates a group. This function is provided for compatibility only. In Microsoft Excel version 5, you can create a group by using the WORKBOOK.SELECT function.

Syntax

WORKGROUP(name_array)
WORKGROUP?(name_array)

Name_array is the list of workbooks or sheets in workbooks that you want grouped.

• If name_array is omitted, the most recently created group is recreated.
• If no group has been created during the current Microsoft Excel session, all open, unhidden worksheets are created as a group.
• If you specify just the name of a workbook, WORKGROUP adds the first sheet of the workbook to the group.

Remarks

WORKGROUP returns the #VALUE! error value and interrupts the macro if it can't find any of the sheets in name_array or if any of the sheets is a chart or module.

Related Functions

FILL.GROUP Fills the contents of the active worksheet's selection to the same area on all other worksheets in the group

WORKBOOK.SELECT Selects one or more sheets in a workbook

List of Command-Equivalent Functions