|
|
|
|
|
|
|
|
|
|
<Spreadsheet>.SelectWorksheet (Function) In french: <Tableur>.SelectFeuille Selects a worksheet (identified by its name) in a Spreadsheet control.
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 index of the current worksheet is returned by CurrentWorksheet.
- The name of the current worksheet is returned by WorksheetName.
- If the sheet does not exist, the function raises a non-fatal error: variable ErrorOccurred is set to True and function ErrorInfo allows you to find out the cause of the error.
- This function can only be used on a Spreadsheet control found in a window.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|