|
|
|
|
|
|
|
|
|
|
<Spreadsheet>.AddName (Function) In french: <Tableur>.AjouteNom Specifies a name to identify a cell found in a Spreadsheet control.
TBLR_TABLEUR1.AjouteNom("PrixHT", "$A$1")
TBLR_TABLEUR1.AjouteNom("TVA", "$A$2")
TBLR_TABLEUR1.AjouteFormule("A3", "PrixHT*TVA")
Syntax
<Spreadsheet control>.AddName(<Cell name> , <Cell> [, <Range> [, <Comment>]])
<Spreadsheet control>: Control name Name of the Spreadsheet control to be used. <Cell name>: Character string Name that will be given to the cell.Caution: - This parameter must not correspond to a cell name ("A1" for example) or to a function name ("SUM" for example).
- This parameter must contain no space character.
- If the specified name is invalid or already exists, the function <Spreadsheet>.AddName fails: variable ErrorOccurred is set to True and function ErrorInfo is used to find out the cause of the error.
<Cell>: Character string Cell to name.
Please note: Absolute coordinates must be used to designate the cell (e.g. "$A$1").
Indeed, the coordinates are relative in a cell name. Using the notation "A1", "A2", ... can lead to circular referencing errors.. <Range>: Optional integer Number of the worksheet where the name can be used. If this parameter is not specified or if it is set to 0, the name can be used in all the worksheets. <Comment>: Optional character string Comment associated with the cell name (up to 255 characters). Remarks The names are not case sensitive (uppercase/lowercase characters)
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|