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 currently selected sheets or macro sheets 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
Return to index