WORKBOOK.SELECT

Macro Sheets Only

Equivalent to selecting a sheet or group of sheets in the active workbook. If you select a group of sheets, subsequent commands effect all the sheets in the group.

Syntax

WORKBOOK.SELECT(name_array, active_name, replace)

Name_array is a horizontal array of text names of sheets you want to select. If name_array is omitted, no sheets are selected.

Active_name is the name of a single sheet in the workbook that you want to be the active sheet. If active_name is omitted, the first sheet in name_array is made the active sheet.

Replace specifies whether the currrently selected sheets or macrosheets are to be replaced by name_array. If TRUE or omitted, then the current sheet selection is replaced by name_array. If FALSE, then name_array will be appended to the current sheet.

Related Functions

GET.WORKBOOK Returns information about a workbook

SELECT Selects a cell, worksheet object, or chart item

List of Command-Equivalent Functions