Fonctions Macro control

[ ] indicates optional parameters

ARGUMENT([nom]; [type]; [référence])
ARRETER([annuler_fermer])
ATTEINDRE(référence)
ATTENDRE([numéro_de_série])
FIN.SI()
POSER.NOM(nom_texte; [valeur])
POSER.VALEUR(référence; valeurs)
POUR(compteur_texte; no_départ; no_fin; [valeur_du_pas])
POUR.CELLULE(nom_réf; [réf_zone]; [pas_cellules_vides])
RECOMMENCER([no_niveau])
RETOUR([valeur])
SI(test_logique)
SINON()
SINON.SI(test_logique)
SORTIR.BOUCLE()
SUIVANT()
TANT.QUE(test_logique)


Fonctions Macro control

ARGUMENT([nom]; [type]; [référence])

Defines an argument for a custom function.

nomThe defined name that will be assigned to the argument. If this parameter is omitted then no name will be assigned.
typeThe 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):
1Nombre
2Texte
4Logique
8Référence
16Erreur
64Matrice
If this parameter is omitted it defaults to 7.
référenceThe cell reference where the argument value will be stored. If this parameter is omitted then the argument value will not be stored.


ARRETER([annuler_fermer])

Terminates all running macros.

annuler_fermerWhether, in an Auto_Close macro, to prevent the workbook from being closed (not currently implemented).


ATTEINDRE(référence)

Forces the macro to continue with the statement at the reference.

référenceThe reference of the cell where macro execution is to continue.


ATTENDRE([numéro_de_série])

Forces the macro to wait until the date/time specified by the serial number.

numéro_de_sérieThe date/time when the macro is to resume. If this parameter is omitted the macro does not wait.


FIN.SI()

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_texteThe defined name to use.
valeurThe 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érenceThe cells where the values are to be stored.
valeursThe 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_texteA defined name that will be used to store the current index.
no_départThe initial value to be assigned to the counter.
no_finThe last value to be assigned to the counter.
valeur_du_pasThe 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éfA defined name that will be used to store the current reference.
réf_zoneThe range of cells to be processed.
If this parameter is omitted it defaults to the current selection.
pas_cellules_videsWhether blank cells are to be skipped. The possible values are:
FAUXAll cells in the area are processed
VRAIOnly the non-blank cells in the area are processed
If this parameter is omitted it defaults to FAUX.


RECOMMENCER([no_niveau])

Specifies the number of levels that will be skipped when this macro returns.

no_niveauThe number of levels to skip. If this parameter is omitted then all levels are skipped.


RETOUR([valeur])

Forces the macro to end, and if it is a custom function then to return the specified value.

valeurFor custom functions, the value to be returned.


SI(test_logique)

Specifies a logical test that conditions the execution of a block of statements.

test_logiqueAn expression that results in VRAI or FAUX.


SINON()

Introduces the block of statements to be processed when the corresponding SI or SINON.SI condition is false.



SINON.SI(test_logique)

Specifies another logical test that conditions a block of statements when the corresponding SI or SINON.SI condition is false.

test_logiqueAn expression that results in VRAI or FAUX.


SORTIR.BOUCLE()

Ends the processing of a POUR, POUR.CELLULE or TANT.QUE loop. The macro will continue with the statement after the SUIVANT function.



SUIVANT()

Specifies the end of the block of statements contained in a POUR, POUR.CELLULE or TANT.QUE loop.



TANT.QUE(test_logique)

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_logiqueAn expression that results in VRAI or FAUX.