Fonctions Macro control
[ ] indicates optional parameters
ARGUMENT([nom]; [type]; [référence])ARGUMENT([nom]; [type]; [référence])
Defines an argument for a custom function.
nom | The defined name that will be assigned to the argument. If this parameter is omitted then no name will be assigned. | ||||||||||||
type | The acceptable data type(s) for the argument value. It can be any combination of the following (to specify more than one value, add the numbers together): | ||||||||||||
| |||||||||||||
If this parameter is omitted it defaults to 7. | |||||||||||||
référence | The cell reference where the argument value will be stored. If this parameter is omitted then the argument value will not be stored. |
Terminates all running macros.
annuler_fermer | Whether, in an Auto_Close macro, to prevent the workbook from being closed (not currently implemented). |
Forces the macro to continue with the statement at the reference.
référence | The reference of the cell where macro execution is to continue. |
Forces the macro to wait until the date/time specified by the serial number.
numéro_de_série | The date/time when the macro is to resume. If this parameter is omitted the macro does not wait. |
Specifies the end of the block of statements conditioned by the corresponding SI or SINON.SI.
POSER.NOM(nom_texte; [valeur])
Assigns a defined name to the specified value.
nom_texte | The defined name to use. |
valeur | The value to be associated with the name. If this parameter is omitted then the name is deleted. |
POSER.VALEUR(référence; valeurs)
Stores the specified values in the specified cells on the macro sheet. Do not use this function to try to update cells on a worksheet.
référence | The cells where the values are to be stored. |
valeurs | The values to be stored. |
POUR(compteur_texte; no_départ; no_fin; [valeur_du_pas])
Performs a group of instructions a specified number of times. The end of the group is indicated by a SUIVANT function.
compteur_texte | A defined name that will be used to store the current index. |
no_départ | The initial value to be assigned to the counter. |
no_fin | The last value to be assigned to the counter. |
valeur_du_pas | The value to be added to the counter each time around the loop. |
If this parameter is omitted it defaults to 1. |
POUR.CELLULE(nom_réf; [réf_zone]; [pas_cellules_vides])
Performs a group of instructions for each cell in a specified area. The end of the group is indicated by a SUIVANT function.
nom_réf | A defined name that will be used to store the current reference. | ||||
réf_zone | The range of cells to be processed. | ||||
If this parameter is omitted it defaults to the current selection. | |||||
pas_cellules_vides | Whether blank cells are to be skipped. The possible values are: | ||||
| |||||
If this parameter is omitted it defaults to FAUX. |
Specifies the number of levels that will be skipped when this macro returns.
no_niveau | The number of levels to skip. If this parameter is omitted then all levels are skipped. |
Forces the macro to end, and if it is a custom function then to return the specified value.
valeur | For custom functions, the value to be returned. |
Specifies a logical test that conditions the execution of a block of statements.
test_logique | An expression that results in VRAI or FAUX. |
Introduces the block of statements to be processed when the corresponding SI or SINON.SI condition is false.
Specifies another logical test that conditions a block of statements when the corresponding SI or SINON.SI condition is false.
test_logique | An expression that results in VRAI or FAUX. |
Ends the processing of a POUR, POUR.CELLULE or TANT.QUE loop. The macro will continue with the statement after the SUIVANT function.
Specifies the end of the block of statements contained in a POUR, POUR.CELLULE or TANT.QUE loop.
Specifies a logical test that conditions the execution of a block of statements multiple times. The statements between the TANT.QUE and SUIVANT functions will be repeated as long as the logical test returns the value VRAI.
test_logique | An expression that results in VRAI or FAUX. |