Equivalent to choosing the Across Worksheets command from the Fill submenu on the Edit menu. Copies the contents of the active worksheet's selection to the same area on all other worksheets in the group. Use FILL.GROUP to fill a range of cells on all worksheets in a group at once.
Syntax
FILL.GROUP(type_num)
FILL.GROUP?(type_num)
Type_num is a number from 1 to 3 that corresponds to the choices in the Fill Across Worksheets dialog box.
| Type_num | Type of information filled |
| 1 | All |
| 2 | Contents |
| 3 | Formats |
Related Functions
NEW Creates a new workbook
WORKBOOK.SELECT Selects one or more sheets in a workbook
Return to index