|
|
|
|
<Spreadsheet>.SelectWorksheet (Function) In french: <Tableur>.SelectFeuille Selects a worksheet (identified by its name) in a Spreadsheet control. // [Go to Worksheet] button PSHEET_MySpreadsheet.SelectWorksheet(EDT_NameWorksheet_To_Select) IF ErrorOccurred = True THEN Error(ErrorInfo()) ELSE STC_MyWorksheet = PSHEET_MySpreadsheet.CurrentWorksheet END
Syntax
<Spreadsheet control>.SelectWorksheet(<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…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|