|
|
|
|
|
|
|
|
SpreadsheetSelectWorksheet (Function) In french: TableurSelectFeuille Selects a worksheet (identified by its name) in a Spreadsheet control.
// [Go to Worksheet] button
SpreadsheetSelectWorksheet(PSHEET_MySpreadsheet, EDT_NameWorksheet_To_Select)
IF ErrorOccurred = True THEN
Error(ErrorInfo())
ELSE
STC_MyWorksheet = PSHEET_MySpreadsheet.CurrentWorksheet
END
Syntax
SpreadsheetSelectWorksheet(<Spreadsheet control> , <Worksheet>)
<Spreadsheet control>: Control name Name of the Spreadsheet control to be used. <Worksheet>: Character string Name of the worksheet to select. Remarks - The subscript of the current worksheet is returned by CurrentWorksheet.
- The name of the current worksheet is returned by WorksheetName.
- If the worksheet does not exist, the function triggers a non-fatal error: the ErrorOccurred variable is set to True and ErrorInfo returns the details of the error.
- This function can only be used on a Spreadsheet control found in a window.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|