Fonctions Macro command

[ ] indicates optional parameters

ACTIVER([fenêtre_texte]; [no_volet])
ACTIVER.CLASSEUR(nom_de_la_feuille)
ACTIVER.OBJET([texte_identificateur_objet]; [active_valeur_logique])
ACTIVER.PREC([classeur_texte])
ACTIVER.SUIV([classeur_texte])
AFFECTER.A.OBJET([réf_macro])
AFFICHER.CELLULE.ACTIVE()
AFFICHER.CLASSEUR([texte_feuille])
AIRES(no_type; [supprimer_superposition])
AJOUTER.TEXTE(no_attacher_à; [no_série]; [no_point])
ALERTE(message_texte; [no_type]; [identificateur_aide])
ANNULER()
ARRIERE.PLAN()
AXES([x_principal]; [y_principal]; [x_secondaire]; [y_secondaire])
BARRES(no_type; [supprimer_superposition])
BIP([nombre_de_son])
CALCULER.DOCUMENT()
CALCULER.MAINTENANT()
CELLULE.ACTIVE()
CELLULE.APPELANTE()
CLASSEUR.PRECEDENT()
CLASSEUR.SUIVANT()
COLLAGE.SPECIAL([no_coller]; [opération]; [non_blanc]; [transposition])
COLLER([référence])
COMMENTAIRES([ajouter_texte]; [référence_cellule]; [caractère_début]; [no_caractères])
COMPLETER.SELECTION(formule_texte; [référence])
CONVERSION.FORMULE(formule_texte; origine_a1; [vers_a1]; [vers_abs]; [réf_rel])
COPIER([réf_origine]; [réf_destination])
COUPER([réf_origine]; [réf_destination])
COURBES(no_type; [supprimer_superposition])
CREER.OBJET(type_objet; réf1; [dist_x1]; [dist_y1]; réf2; [dist_x2]; [dist_y2]; [texte]; [plein]; [modifiable])
DEFILEMENTH(position; [col_log])
DEFILEMENTV(position; [ligne_log])
DEFINIR.NOM(nom_texte; [réfère_à]; [type_macro]; [raccourci_texte]; [masqué]; [catégorie]; [local])
DEFINIR.VALEUR.CONTROLE([valeur])
DEREF(référence)
DOCUMENTS([no_type]; [texte])
DONNEES.SERIE([lig_col]; [no_type]; [no_date]; [valeur_pas]; [valeur_arrêt]; [tendance])
DUPLIQUER()
ECHELLE([no_min]; [no_max]; [princ]; [second]; [coupe]; [logarithmique]; [inversé]; [max])
ECRAN([valeur_logique])
EDITION.SUPPRIMER([no_décaler])
EFFACER([no_type])
ENCADREMENT([contour]; [gauche]; [droit]; [haut]; [bas]; [ombré]; [couleur_contour]; [couleur_gauche]; [couleur_droite]; [couleur_haut]; [couleur_bas])
ENREGISTRER()
ENREGISTRER.DIALOGUE([nom_fichier_init]; [titre]; [texte_bouton]; [filtre_fichier]; [filtre_index])
ENREGISTRER.SOUS([document_texte]; [no_type]; [mot_de_passe_prot]; [copie]; [mot_de_passe_rés_écriture]; [lecture_seule_rec])
ENTRÉE(message_texte; [no_type]; [texte_titre]; [par_défaut]; [pos_x]; [pos_y]; [réf_aide])
ERREUR(activer_valeur_logique; [réf_macro])
ETIQUETTES.DONNEES([affichage_option]; [texte_auto]; [affichage_légende])
EVALUER(formule_texte)
F.DIMENSION(no_fichier)
F.ECRIRE(no_fichier; texte)
F.ECRIRE.LIGNE(no_fichier; texte)
F.FERMER(no_fichier)
F.LIRE(no_fichier; no_car)
F.LIRE.LIGNE(no_fichier)
F.OUVRIR(fichier_texte; [no_accès])
F.POSITION(no_fichier; [no_position])
FICHIER.FERMER([valeur_logique_enregistrer]; [valeur_logique_routage])
FICHIER.SUPPRIMER(fichier_texte)
FICHIERS([répertoire_texte])
FIGER.VOLETS([valeur_logique]; [colonne]; [ligne])
FILTRE([champ]; [critère1]; [options]; [critère2])
FILTRE.AFFICHER.TOUS()
FILTRE.ELABORE(options; réf_liste; [réf_critères]; [réf_copie]; [sans_doublon])
FORMAT.DEPLACEMENT([pos_x]; [pos_y]; [réf])
FORMAT.LEGENDE(no_position)
FORMAT.NOMBRE(format_texte)
FORMAT.TEXTE([align_x]; [align_y]; [no_orientation]; [texte_auto]; [dimension_auto]; [afficher_légende]; [afficher_valeur]; [ajouter_retrait])
FORMULE(formule_texte; [référence])
FORMULE.MATRICIELLE(formule_texte; [référence])
GRAPHIQUE.ANNEAU(no_type; [supprimer_superposition])
GRILLE()
HAUTEUR.LIGNE([hauteur]; [référence]; [standard]; [type_nom])
HISTOGRAMMES(no_type; [supprimer_superposition])
INSERER([no_décaler])
INSERER.CLASSEUR([no_type])
INSERER.TITRE([graphique]; [y_principal]; [x_principal]; [y_secondaire]; [x_secondaire])
LARGEUR.COLONNE([no_largeur]; [référence]; [standard]; [no_type]; [no_larg_standard])
LARGEUR.STANDARD([no_standard])
LEGENDE([valeur_logique])
LIGNEH([no_col])
LIGNEV([no_lignes])
LIRE.CELLULE(no_type; [référence])
LIRE.COMMENTAIRES([réf_cellule]; [car_départ]; [no_car])
LIRE.FORMULE(référence)
LIRE.NOM(nom_texte; [type_info])
LIRE.OBJET(no_type; [identificateur_objet]; [no_départ]; [nb_car]; [élément_index])
MASQUER.CLASSEUR([texte_feuille]; [très_masqué])
MASQUER.OBJET([texte_identificateur_objet]; [masque_valeur_logique])
MESSAGE(valeur_logique; [texte])
MODIFIER.COULEUR(no_couleur; [valeur_rouge]; [valeur_vert]; [valeur_bleu])
MODIFIER.SELECTION(no_direction)
MODIFIER.SERIES([no_série]; [réf_nom]; [réf_x]; [réf_y]; [réf_z]; [ordre_traçage])
MOTIFS([amotif]; [aplan]; [afond])
MOTIFS([lauto]; [lstyle]; [lcoul]; [lép]; [flargeur]; [flongueur]; [ftype])
MOTIFS([cauto]; [cstyle]; [ccoul]; [cép]; [ombré]; [aauto]; [amotif]; [aplan]; [afond]; [arrondis]; [nouvui])
MOTIFS([cauto]; [cstyle]; [ccoul]; [cép]; [ombré]; [aauto]; [amotif]; [aplan]; [afond]; [inv]; [sélectionner]; [nouv_rempli])
MOTIFS([lauto]; [lstyle]; [lcoul]; [lép]; [mauto]; [mstyle]; [mplan]; [mfond]; [sélectionner]; [lissage])
NOMMER.CLASSEUR(ancien_nom; nouveau_nom)
NOMS([document_texte]; [no_type]; [texte])
NOUVEAU.DOCUMENT([no_type]; [séries_xy]; [ajouter])
NUAGES.DE.POINTS(no_type; [supprimer_superposition])
OPTIONS.AFFICHAGE([formule]; [état]; [commentaires]; [affichage_info]; [no_objet]; [sauts_pages]; [formules]; [quadrillage]; [no_couleur]; [en-têtes]; [plan]; [zéros]; [défil_horiz]; [défil_vert]; [onglets_feuilles])
OUVRIR(fichier_texte; [mise_à_jour]; [lecture_seule]; [format]; [mot_passe_prot]; [mot_passe_rés_écriture]; [ignore_lecture_seule_rec]; [fichier_origine]; [séparateur_personnalisé]; [ajouter]; [modifiable]; [accès_fichier]; [notification]; [convertisseur])
OUVRIR.DIALOGUE([filtre_fichier]; [texte_bouton]; [titre]; [filtre_index])
PAGEH([no_fenêtres])
PAGEV([no_fenêtres])
PALETTE.COULEURS(fichier_texte)
POSITION([position_horizontale]; [renvoi_ligne]; [position_verticale]; [orientation]; [ajouter_retrait])
PREMIER.PLAN()
PROPRIETES.BARRE.DEFILEMENT([valeur]; [min]; [max]; [inc]; [page]; [liaison]; [ombrage_3D])
PROPRIETES.CASE.A.COCHER([valeur]; [liaison]; [texte_touche_accès_rapide]; [texte_touche_accès_rapide2]; [ombrage_3D])
PROPRIETES.ETIQUETTE([texte_touche_accès_rapide]; [texte_touche_accès_rapide2]; [ombrage_3d])
PROPRIETES.OBJET([type_déplacement]; [imprimer_objet])
PROPRIETES.POLICE([police]; [style_police]; [taille]; [barré]; [exposant]; [indice]; [relief]; [ombrage]; [souligné]; [couleur]; [normal]; [fond]; [car_début]; [nb_car])
PROPRIETES.ZONE.LISTE([plage]; [liaison]; [taille_déroul]; [sélection_multiple]; [ombrage_3d])
PROTECTION.CELLULE([verrouillage]; [masquage])
PROTEGER.DOCUMENT([contenu]; [fenêtres]; [mot_de_passe]; [objets]; [scénarios])
QUADRILLAGE([x_princ]; [x_sec]; [y_princ]; [y_sec]; [z_princ]; [z_sec]; [effet_2D])
QUITTER()
RADAR(no_type; [supprimer_superposition])
RECHERCHER.PRECEDENT.SEL()
RECHERCHER.SELECTION(texte; nb_ds; nb_à; nb_par; [nb_dir]; [maj_min])
RECHERCHER.SUIVANT.SEL()
RECOPIER.BAS()
RECOPIER.DROITE()
RECOPIER.GAUCHE()
RECOPIER.HAUT()
REFABS(réf_texte; réf)
REFREL(réf; réf_rel)
REFTEXTE(texte; [a1])
REMPLACER.CELLULE(texte_cherché; texte_remplacé; [comment]; [par]; [cellule_active]; [maj_min])
REPERTOIRE([chemin_accès])
SECTEURS(no_type; [supprimer_superposition])
SEL.DERNIERE.CELLULE()
SELECTION()
SELECTION.ATTEINDRE([référence]; [coin])
SELECTIONNER([sélection]; [cellule_active])
SELECTIONNER([identificateur_objet_texte]; [remplacer])
SELECTIONNER([élément_texte]; [point_unique])
SELON.DOUBLECLIC([feuille_texte]; [macro_texte])
SELON.ENTREE([feuille_texte]; [macro_texte])
SELON.FEUILLE([feuille_texte]; [macro_texte]; [valeur_logique_activation])
SUPPRIMER.CLASSEUR([texte_feuille])
SUPPRIMER.FORMAT(format_texte)
SUPPRIMER.NOM(nom_texte)
TEXTEREF(référence; [a1])
TOUCHE.ARRET(activer_valeur_logique; [réf_macro])
TRIER([orientation]; [clé_1]; [ordre_1]; [clé_2]; [ordre_2]; [clé_3]; [ordre_3]; [en_tête]; [perso]; [maj_min])
VALEUR.CIBLE(cellule_cible; valeur_cible; cellule_variable)
ZONE.TEXTE(ajouter_texte; [identificateur_objet_texte]; [no_départ]; [no_car])
ZOOM([facteur_zoom])


Fonctions Macro command

ACTIVER([fenêtre_texte]; [no_volet])

Specifies the workbook, sheet and/or pane that is to be active.

fenêtre_texteThe workbook and/or sheet name. If this parameter is omitted then the active window is not changed.
no_voletFor a split window, specifies which pane is to be active. The possible values are:
1Upper or upper left.
2Upper right.
3Lower or lower left.
4Lower right.
If this parameter is omitted it then the active pane is not changed.


ACTIVER.CLASSEUR(nom_de_la_feuille)

Specifies the sheet that is to be the active worksheet.

nom_de_la_feuilleThe sheet that is to be the active worksheet.


ACTIVER.OBJET([texte_identificateur_objet]; [active_valeur_logique])

Specifies whether an object should respond to mouse clicks.

texte_identificateur_objetThe object to be enabled or disabled. If this parameter is omitted the currently selected object is used.
active_valeur_logiqueWhether the object is enabled. The possible values are:
VRAIThe object is enabled.
FAUXThe object is disabled.
If this parameter is omitted the setting is not changed.


ACTIVER.PREC([classeur_texte])

Simulates the Ctrl+Page Up or Ctrl+Shift+Tab key combination.

classeur_texteThe workbook for which the previous sheet is to be selected. If this parameter is omitted then the previous workbook is selected.


ACTIVER.SUIV([classeur_texte])

Simulates the Ctrl+Page Down or Ctrl+Tab key combination.

classeur_texteThe workbook for which the next sheet is to be selected. If this parameter is omitted then the next workbook is selected.


AFFECTER.A.OBJET([réf_macro])

Assigns a macro to an object.

réf_macroThe reference of the macro to be assigned. If this parameter is omitted then any existing macro is removed.


AFFICHER.CELLULE.ACTIVE()

Scrolls the active cell into view.



AFFICHER.CLASSEUR([texte_feuille])

Simulates the Format Feuille Afficher menu option.

texte_feuilleThe name of the sheet to unhide. If this parameter is omitted it defaults to the first hidden sheet.


AIRES(no_type; [supprimer_superposition])

Changes the active chart to an area chart.

no_typeThe format to be applied to the chart. The possible values are:
1no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, no drop lines
2no horizontal gridlines, no vertical gridlines, 100% y axis, no data labels, no drop lines (not currently implemented)
3no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, drop lines (not currently implemented)
4horizontal gridlines, vertical gridlines, linear y axis, no data labels, no drop lines
5no horizontal gridlines, no vertical gridlines, linear y axis, data labels, no drop lines
supprimer_superpositionWhether to delete any overlays (not currently implemented).


AJOUTER.TEXTE(no_attacher_à; [no_série]; [no_point])

Attaches default text to the active chart. The SELECTIONNER and FORMULE functions can be used to change the text.

no_attacher_àThe item where the default text is to be attached. The possible values are:
1Chart title
2Primary y-axis title
3Primary x-axis title
4Data label (not currently implemented)
5Secondary y-axis title (not currently implemented)
6Secondary x-axis title (not currently implemented)
no_sérieThe series number of the data label (not currently implemented)
no_pointThe point number of the data label (not currently implemented)


ALERTE(message_texte; [no_type]; [identificateur_aide])

Displays a message box containing the specified text. It returns VRAI if the OK button is pressed, otherwise FAUX.

message_texteThe text to be displayed in the message box.
no_typeThe type of message box to be displayed. The possible values are:
1A box containing a question mark icon and OK and Annuler buttons.
2A box containing an information icon and an OK button.
3A box containing an exclamation icon and an OK button.
If this parameter is omitted it defaults to 2.
identificateur_aideA reference to a Help topic (not currently implemented).


ANNULER()

Simulates the Modifier Annuler menu option.



ARRIERE.PLAN()

Changes the order of the objects on the active worksheet by moving the currently selected object to the back.



AXES([x_principal]; [y_principal]; [x_secondaire]; [y_secondaire])

Changes the active chart axes.

x_principalWhether to draw the X-axis. The possible values are:
FAUXDo not draw the X-axis.
VRAIDo draw the X-axis.
If this parameter is omitted the setting is not changed.
y_principalWhether to draw the Y-axis. The possible values are:
FAUXDo not draw the Y-axis.
VRAIDo draw the Y-axis.
If this parameter is omitted the setting is not changed.
x_secondaireWhether to draw the secondary X-axis (not currently implemented).
y_secondaireWhether to draw the secondary Y-axis (not currently implemented).


BARRES(no_type; [supprimer_superposition])

Changes the active chart to a bar chart.

no_typeThe format to be applied to the chart. The possible values are:
1no horizontal gridlines, no vertical gridlines, linear x axis, no data labels, not stacked, no series lines
2no horizontal gridlines, no vertical gridlines, linear x axis, no data labels, not stacked, no series lines
3no horizontal gridlines, no vertical gridlines, linear x axis, no data labels, stacked, no series lines (not currently implemented)
4no horizontal gridlines, no vertical gridlines, linear x axis, no data labels, not stacked, no series lines
5no horizontal gridlines, no vertical gridlines, 100% x axis, no data labels, stacked, no series lines (not currently implemented)
6no horizontal gridlines, vertical gridlines, linear x axis, no data labels, not stacked, no series lines
7no horizontal gridlines, no vertical gridlines, linear x axis, data values, not stacked, no series lines
8no horizontal gridlines, no vertical gridlines, linear x axis, no data labels, not stacked, no series lines
9no horizontal gridlines, no vertical gridlines, linear x axis, no data labels, stacked, series lines (not currently implemented)
10no horizontal gridlines, no vertical gridlines, 100% x axis, no data labels, stacked, series lines (not currently implemented)
supprimer_superpositionWhether to delete any overlays (not currently implemented).


BIP([nombre_de_son])

Causes the computer to beep.

nombre_de_sonA number from 1 to 4 indicating which type of beep is to be produced (not currently implemented - all values will produce the same tone). If this parameter is omitted it defaults to 1.


CALCULER.DOCUMENT()

Causes the current worksheet to be recalculated.



CALCULER.MAINTENANT()

Causes all worksheets to be recalculated.



CELLULE.ACTIVE()

Returns a reference which represents the current position of the cursor on the active worksheet.



CELLULE.APPELANTE()

Returns information about the caller of the macro.

Macro called from:Function returns:
User-defined functionreference of cell containing function call
User-defined function in array formulareference of array formula range
Attached to control or drawing objectobject identifier
Auto_Open macrofile name
Manually (control key combination)error value #REF!
SELON.DOUBLECLIC macroreference of cell that was double-clicked
SELON.ENTREE macroreference of cell where data was entered
SELON.FEUILLE macroerror value #REF!


CLASSEUR.PRECEDENT()

Simulates the Ctrl+Page Up key combination.



CLASSEUR.SUIVANT()

Simulates the Ctrl+Page Down key combination.



COLLAGE.SPECIAL([no_coller]; [opération]; [non_blanc]; [transposition])

Simulates the Modifier Collage spécial menu option.

no_collerThe type of information to be pasted. The possible values are:
1Tout
2Formules
3Valeur
4Formats
5Commentaires
6Tout sauf les bordures
If this parameter is omitted it defaults to 1.
opérationThe way in which the data being pasted is merged with existing data. The possible values are:
1Aucun
2Ajouter
3Soustraction
4Produit
5Division
If this parameter is omitted it defaults to 1.
non_blancWhether to ignore blank cells in the data being pasted. The possible values are:
FAUXBlank cells are included.
VRAIBlank cells are skipped.
If this parameter is omitted it defaults to FAUX.
transpositionWhether to transpose the data being pasted. The possible values are:
FAUXData is not transposed.
VRAIData is transposed. (Not currently implemented)
If this parameter is omitted it defaults to FAUX.


COLLER([référence])

Simulates the Modifier Coller menu option.

référenceThe cells where the copied information is to be pasted. If this parameter is omitted it defaults to the current selection on the active worksheet.


COMMENTAIRES([ajouter_texte]; [référence_cellule]; [caractère_début]; [no_caractères])

Simulates the Insérer Commentaire menu option.

ajouter_texteThe text that is to be added. If this parameter is omitted it defaults to an empty string.
référence_celluleThe cell where the comment is to be inserted. If this parameter is omitted it defaults to the active cell.
caractère_débutThe start position in an existing comment where the new text is to be inserted. If this parameter is omitted it defaults to 1.
no_caractèresThe length of text in an existing comment that is to be replaced. If this parameter is omitted it defaults to the length of the existing text.


COMPLETER.SELECTION(formule_texte; [référence])

Enters the specified formula in the specified range. Any references in the formula must be in R1C1 format. The CONVERSION.FORMULE function can be used to convert references.

formule_texteThe formula to be inserted.
référenceThe reference where formula to be inserted. If this parameter is omitted it defaults to the current selection on the active worksheet.


CONVERSION.FORMULE(formule_texte; origine_a1; [vers_a1]; [vers_abs]; [réf_rel])

Converts the references in the specified formula from one type to another.

formule_texteThe formula to be converted.
origine_a1Whether references in the formula are in A1 or R1C1 format. The possible values are:
FAUXThe references are in R1C1 format
VRAIThe references are in A1 format
vers_a1Whether references in the formula are converted to A1 or R1C1 format. The possible values are:
FAUXThe references are converted to R1C1 format
VRAIThe references are converted to A1 format
If this parameter is omitted the format is not changed.
vers_absWhether references in the formula are converted to use absolute or relative reference type. The possible values are:
1Absolute row, absolute column
2Absolute row, relative column
3Relative row, absolute column
4Relative row, relative column
If this parameter is omitted the reference type is not changed.
réf_relThe cell that R1C1 references are relative to. If this parameter is omitted it defaults to the cell containing this function.


COPIER([réf_origine]; [réf_destination])

Simulates the Modifier Copier menu option.

réf_origineThe cells that are to be copied to the clipboard. If this parameter is omitted it defaults to the current selection on the active worksheet.
réf_destinationThe cells where the copied information is to be pasted. If this parameter is omitted then the cells are not pasted.


COUPER([réf_origine]; [réf_destination])

Simulates the Modifier Couper menu option.

réf_origineThe cells that are to be cut to the clipboard. If this parameter is omitted it defaults to the current selection on the active worksheet.
réf_destinationThe cells where the cut information is to be pasted. If this parameter is omitted then the cells are not pasted.


COURBES(no_type; [supprimer_superposition])

Changes the active chart to a line chart.

no_typeThe format to be applied to the chart. The possible values are:
1markers, straight lines, no horizontal gridlines, no vertical gridlines, linear y axis, no hi-lo lines
2no markers, straight lines, no horizontal gridlines, no vertical gridlines, linear y axis, no hi-lo lines
3markers, no lines, no horizontal gridlines, no vertical gridlines, linear y axis, no hi-lo lines
4markers, straight lines, horizontal gridlines, no vertical gridlines, linear y axis, no hi-lo lines
5markers, straight lines, horizontal gridlines, vertical gridlines, linear y axis, no hi-lo lines
6markers, straight lines, horizontal gridlines, no vertical gridlines, logarithmic y axis, no hi-lo lines
7markers, no lines, no horizontal gridlines, no vertical gridlines, linear y axis, hi-lo lines (not currently implemented)
8high-low-close stock chart (not currently implemented)
9open-high-low-close stock chart (not currently implemented)
10no markers, curved lines, no horizontal gridlines, no vertical gridlines, linear y axis, no hi-lo lines (not currently implemented)
supprimer_superpositionWhether to delete any overlays (not currently implemented).


CREER.OBJET(type_objet; réf1; [dist_x1]; [dist_y1]; réf2; [dist_x2]; [dist_y2]; [texte]; [plein]; [modifiable])

Simulates the Insérer Object dessin and Insérer Contrôle menu options.

type_objetThe type of object to be created. The possible values are:
1Ligne
2Rectangle
3Ellipse
6Zone de texte
7Bouton de commande
11Case à cocher
12Bouton d'option
14Étiquette
16Toupie
17Barre de défilement
18Zone de liste
19Zone de groupe
20Zone de liste modifiable
réf1The cell containing the top-left corner of the object.
dist_x1The offset in points of the top-left corner of the object from the left edge of the cell. If this parameter is omitted it defaults to 0.
dist_y1The offset in points of the top-left corner of the object from the top edge of the cell. If this parameter is omitted it defaults to 0.
réf2The cell containing the bottom-right corner of the object.
dist_x2The offset in points of the bottom-right corner of the object from the left edge of the cell. If this parameter is omitted it defaults to 0.
dist_y2The offset in points of the bottom-right corner of the object from the top edge of the cell. If this parameter is omitted it defaults to 0.
texteThe text to be assigned to the object. If this parameter is omitted then no text is assigned.
pleinSpecifies whether the object is filled or transparent (not currently implemented).
modifiableSpecifies whether a combo box is editable (not currently implemented).


DEFILEMENTH(position; [col_log])

Scrolls the worksheet horizontally to the specified position.

positionThe proportional or absolute position to scroll to.
col_logWhether the position parameter represents a proportional or absolute column number. The possible values are:
FAUXThe position parameter is a number between 0 and 1 that represents how far across the worksheet to scroll to.
VRAIThe position parameter is a number between 1 and 256 that represents the column number to scroll to.
If this parameter is omitted it defaults to FAUX.


DEFILEMENTV(position; [ligne_log])

Scrolls the worksheet vertically to the specified position.

positionThe proportional or absolute position to scroll to.
ligne_logWhether the position parameter represents a proportional or absolute row number. The possible values are:
FAUXThe position parameter is a number between 0 and 1 that represents how far down the worksheet to scroll to.
VRAIThe position parameter is a number between 1 and 65536 that represents the row number to scroll to.
If this parameter is omitted it defaults to FAUX.


DEFINIR.NOM(nom_texte; [réfère_à]; [type_macro]; [raccourci_texte]; [masqué]; [catégorie]; [local])

Simulates the Insérer Nom Definir Ajouter menu option.

nom_texteA string containing the name to be defined.
réfère_àThe value that is to be assigned to the name. If this parameter is omitted it defaults to a reference to the current selection on the active sheet.
type_macroThe type of macro that this name refers to (not currently implemented).
raccourci_texteThe shortcut key used to activate a command macro. If this parameter is omitted no shortcut key is assigned.
masquéWhether the name is to be hidden in the name definition list. The possible values are:
FAUXShow the name in the list.
VRAIDo not show the name in the list.
If this parameter is omitted it defaults to FAUX.
catégorieIdentifies the category of a custom function (not currently implemented).
localWhether the name is to local to the active sheet. The possible values are:
FAUXThe name is defined as global.
VRAIThe name is defined as local.
If this parameter is omitted it defaults to FAUX.


DEFINIR.VALEUR.CONTROLE([valeur])

Changes the current value of a control.

valeurThe new value for the control. The possible values are:
Case à cocher0Non activée
1Activée
2Grisée
Bouton d'option0Non activée
1Activée
ToupieThe new value of the spin control
Barre de défilementThe new scroll position
Zone de listeThe selected item (0 = no selection)
Zone de liste modifiableThe selected item (0 = no selection)
If this parameter is omitted the setting is not changed.


DEREF(référence)

Returns the values of cells in a reference. You should not need to use this function, as references are automatically converted to values where necessary when they are used in formulas.

référenceThe reference to the cells whose values you want.


DOCUMENTS([no_type]; [texte])

Returns a horizontal array containing the names of the open files.

no_typeSpecifies whether to include add-in workbooks in the list. The possible values are:
1List only open files that are not add-in workbooks.
2List only open files that are add-in workbooks.
3List all open files.
If this parameter is omitted it defaults to 1.
texteA template name that may contain wildcard characters. If this parameter is omitted then all workbook names will be included.


DONNEES.SERIE([lig_col]; [no_type]; [no_date]; [valeur_pas]; [valeur_arrêt]; [tendance])

Simulates the Modifier Recopier Série menu option.

lig_colIndicates whether the series is in rows or columns. The possible values are:
1lignes
2colonnes
If this parameter is omitted it defaults depending on the shape of the current selection.
no_typeThe way in which the series values change. The possible values are:
1Linéaire
2Géométrique
3Date
4Auto (not currently implemented)
If this parameter is omitted it defaults to 1.
no_dateThe way in which the date values change. The possible values are:
1Jour
2Jour ouvré
3Mois
4Année
If this parameter is omitted it defaults to 1.
valeur_pasThe number used to add to or multiply by the series value. If this parameter is omitted it defaults to 1.
valeur_arrêtThe value at which to stop filling the series. If this parameter is omitted then the entire selection is filled.
tendanceIndicates whether to fill the series using trend values calculated from existing data. The possible values are:
FAUXDon't use trend values.
VRAIUse trend values (not currently implemented).
If this parameter is omitted it defaults to FAUX.


DUPLIQUER()

Duplicates the currently selected object.



ECHELLE([no_min]; [no_max]; [princ]; [second]; [coupe]; [logarithmique]; [inversé]; [max])

Changes the attributes of the selected chart value axis scale.

no_minThe minimum value. If this parameter is omitted the setting is not changed.
no_maxThe maximum value. If this parameter is omitted the setting is not changed.
princThe major step value. If this parameter is omitted the setting is not changed.
secondThe minor step value (not currently implemented).
coupeThe value at which the opposite axis crosses this axis (not currently implemented).
logarithmiqueWhether this scale is linear or logarithmic. The possible values are:
FAUXThe scale is linear.
VRAIThe scale is logarithmic.
If this parameter is omitted the setting is not changed.
inverséWhether the scale values are show in reverse order (not currently implemented).
maxWhether the opposite axis crosses this axis at the maximum value (not currently implemented).


ECRAN([valeur_logique])

Controls screen updating while a macro is running.

valeur_logiqueWhether to update the screen while the macro is running. The possible values are:
FAUXDo not update the screen
VRAIDo update the screen
If this parameter is omitted the setting is toggled.


EDITION.SUPPRIMER([no_décaler])

Simulates the Modifier Supprimer menu option.

no_décalerThe way in which the cell deletion is to be processed. The possible values are:
1Décaler les cellules vers la gauche
2Décaler les cellules vers le haut
3Ligne entière
4Colonne entière
If this parameter is omitted it defaults to 2.


EFFACER([no_type])

Simulates the Modifier Effacer menu option.

no_typeThe type of information to clear from the current selection on the active worksheet. The possible values are:
1Effacer tout
2Effacer les formats
3Effacer le contenu
4Effacer les commentaires
If this parameter is omitted it defaults to 3.


ENCADREMENT([contour]; [gauche]; [droit]; [haut]; [bas]; [ombré]; [couleur_contour]; [couleur_gauche]; [couleur_droite]; [couleur_haut]; [couleur_bas])

Simulates the Format Cellules dialog Encadrement page.

contourThe border type to be applied to the outline of the selected cells. The possible values are:
0No border
1Thin
2Medium
3Dashed
4Dotted
5Thick
6Double
7Hairline
If this parameter is omitted the setting is not changed.
gaucheThe border type to be used for the left border of the selected cells. The possible values are the same as for the contour parameter.
If this parameter is omitted the setting is not changed.
droitThe border type to be used for the right border of the selected cells. The possible values are the same as for the contour parameter.
If this parameter is omitted the setting is not changed.
hautThe border type to be used for the top border of the selected cells. The possible values are the same as for the contour parameter.
If this parameter is omitted the setting is not changed.
basThe border type to be used for the bottom border of the selected cells. The possible values are the same as for the contour parameter.
If this parameter is omitted the setting is not changed.
ombréNot implemented.
couleur_contourThe color to be used for the outline border. The possible values are:
0Automatique
1 to 56One of the colors displayed in the Format Cellules dialog Encadrement page
If this parameter is omitted the setting is not changed.
couleur_gaucheThe color to be used for the left border. The possible values are the same as for the couleur_contour parameter.
If this parameter is omitted the setting is not changed.
couleur_droiteThe color to be used for the right border. The possible values are the same as for the couleur_contour parameter.
If this parameter is omitted the setting is not changed.
couleur_hautThe color to be used for the top border. The possible values are the same as for the couleur_contour parameter.
If this parameter is omitted the setting is not changed.
couleur_basThe color to be used for the bottom border. The possible values are the same as for the couleur_contour parameter.
If this parameter is omitted the setting is not changed.


ENREGISTRER()

Simulates the Fichier Enregistrer menu option.



ENREGISTRER.DIALOGUE([nom_fichier_init]; [titre]; [texte_bouton]; [filtre_fichier]; [filtre_index])

Returns a file name from the Fichier Enregistrer Sous dialog box, or FAUX if Annuler is selected.

nom_fichier_initThe suggested file name. If this parameter is omitted it defaults to the name of the active file.
titreReplacement text for the dialog box title. If this parameter is omitted the title is not changed.
texte_boutonReplacement text for the Save button (not currently implemented).
filtre_fichierOne or more file filters, separated by commas. If this parameter is omitted it defaults to "Tous les fichiers (*.*), *.*".
filtre_indexThe index of the initial file filter. If this parameter is omitted it defaults to 1.


ENREGISTRER.SOUS([document_texte]; [no_type]; [mot_de_passe_prot]; [copie]; [mot_de_passe_rés_écriture]; [lecture_seule_rec])

Simulates the Fichier Enregistrer Sous menu option.

document_texteThe name for the saved file. If this parameter is omitted the current name will be used.
no_typeThe type of file to save. The possible values are:
1Excel workbook (xls)
3Tab-delimited text (txt)
6Comma-separated values (csv)
17Excel template (xlt)
If this parameter is omitted it defaults to 1.
mot_de_passe_protThe password required to unprotect a file (not currently implemented).
copieWhether to make a backup of the file (not currently implemented).
mot_de_passe_rés_écritureThe password required to open a read-only file for writing (not currently implemented).
lecture_seule_recWhether to save the file as read-only recommended (not currently implemented).


ENTRÉE(message_texte; [no_type]; [texte_titre]; [par_défaut]; [pos_x]; [pos_y]; [réf_aide])

Displays a message in a dialog box with an area for user input and OK and Annuler buttons. If the OK button is pressed then the text entered by the user is returned. If the Annuler button is pressed then this function returns the value FAUX.

message_texteThe message that you want displayed in the dialog box.
no_typeThe acceptable data type(s) for the data that you want returned. It can be any combination of the following (to specify more than one value, add the numbers together):
0Formule
1Nombre
2Texte
4Logique
8Référence
16Erreur
64Matrice
If this parameter is omitted it defaults to 2.
texte_titreThe title to be used for the dialog box. If this parameter is omitted it defaults to "Input".
par_défautThe text that you want to be initially displayed in the input area of the dialog box. If this parameter is omitted the input area will be blank.
pos_xThe initial x position on the screen where the dialog box will be displayed. If this parameter is omitted it defaults to the center of the screen. (Not currently implemented).
pos_yThe initial y position on the screen where the dialog box will be displayed. If this parameter is omitted it defaults to the center of the screen. (Not currently implemented).
réf_aideThe name of help topic that is to be displayed if the user presses the Help button in the dialog box. If this parameter is omitted then no Help button is displayed. (Not currently implemented).


ERREUR(activer_valeur_logique; [réf_macro])

Specifies the action taken when an error occurs in a macro.

activer_valeur_logiqueWhether to interrupt the macro. The possible values are:
FAUXThe macro continues
VRAIThe macro is interrupted
réf_macroThe macro to be run when an error occurs (not currently implemented)


ETIQUETTES.DONNEES([affichage_option]; [texte_auto]; [affichage_légende])

Changes the active chart data labels.

affichage_optionThe type of label to show. The possible values are:
1Aucun
2Afficher valeur
3Afficher pourcentage
4Afficher étiquette
5Afficher étiquette et pourcentage
If this parameter is omitted the data labels are not changed.
texte_autoWhether to reset the data labels (not currently implemented).
affichage_légendeWhether to show the legend key next to the label (not currently implemented).


EVALUER(formule_texte)

Returns the result of evaluating a formula.

formule_texteThe formula to be evaluated.


F.DIMENSION(no_fichier)

Returns a size of a file.

no_fichierThe file number that was returned by the F.OUVRIR function.


F.ECRIRE(no_fichier; texte)

Writes a string of characters to a file.

no_fichierThe file number that was returned by the F.OUVRIR function.
texteThe text to be written.


F.ECRIRE.LIGNE(no_fichier; texte)

Writes a string of characters to a file, followed by an end of line marker.

no_fichierThe file number that was returned by the F.OUVRIR function.
texteThe text to be written.


F.FERMER(no_fichier)

Closes a file that was previously opened by the F.OUVRIR function.

no_fichierThe file number that was returned by the F.OUVRIR function.


F.LIRE(no_fichier; no_car)

Returns a string of characters from a file.

no_fichierThe file number that was returned by the F.OUVRIR function.
no_carThe number of characters to read.


F.LIRE.LIGNE(no_fichier)

Returns a string of characters from a file, up to the next end of line marker.

no_fichierThe file number that was returned by the F.OUVRIR function.


F.OUVRIR(fichier_texte; [no_accès])

Opens a file for reading or writing. The return value is a file number that can be passed as a parameter to the F.LIRE, F.LIRE.LIGNE, F.ECRIRE, F.ECRIRE.LIGNE, F.POSITION, F.DIMENSION and F.FERMER functions.

fichier_texteThe name of the file to open.
no_accèsThe access required to the file. The possible values are:
1Open the file for reading and writing. The file must already exist.
2Open the file for reading only. The file must already exist.
3Create a new file for reading and writing. The file will be cleared if it already exists.
If this parameter is omitted it defaults to 1.


F.POSITION(no_fichier; [no_position])

Returns the current read/write position in a file, and optionally allows you to change it.

no_fichierThe file number that was returned by the F.OUVRIR function.
no_positionThe location where the next read or write will occur.
If this parameter is omitted the current position is not changed.


FICHIER.FERMER([valeur_logique_enregistrer]; [valeur_logique_routage])

Simulates the Fichier Fermer menu option.

valeur_logique_enregistrerWhether to save a changed file before closing it. The possible values are:
FAUXDo not save the file
VRAISave the file
If this parameter is omitted then the prompt is displayed.
valeur_logique_routageWhether to route the file after closing it (not currently implemented).


FICHIER.SUPPRIMER(fichier_texte)

Deletes a file.

fichier_texteThe name of the file to be deleted.


FICHIERS([répertoire_texte])

Returns a horizontal array containing the names of the files in a directory.

répertoire_texteA template name that may contain wildcard characters. If this parameter is omitted then all file names will be included.


FIGER.VOLETS([valeur_logique]; [colonne]; [ligne])

Simulates the Format Figer menu option.

valeur_logiqueWhether to freeze or unfreeze the panes. The possible values are:
FAUXUnfreeze the panes
VRAIFreeze the panes
If this parameter is omitted the setting is toggled.
colonneThe number of columns to be frozen. If this parameter is omitted all columns left of the cursor cell are frozen.
ligneThe number of rows to be frozen. If this parameter is omitted all rows above the cursor cell are frozen.


FILTRE([champ]; [critère1]; [options]; [critère2])

Simulates the Format Données Filtre Filtre automatique menu option.

champThe filter column number whose criteria are to be changed. The columns are number from left to right, with 1 being the first filtered column. If this parameter is omitted the filter is just turned on or off.
critère1A string specifying the criteria to be used. If this parameter is omitted any filter criteria are removed from the specified column.
optionsThe combination operation when multiple criteria are used. The possible values are:
1Et
2Ou
If this parameter is omitted the second criteria is not used.
critère2A string specifying the criteria to be used. If this parameter is omitted the second criteria is not used.


FILTRE.AFFICHER.TOUS()

Simulates the Format Données Filtre Afficher tout menu option.



FILTRE.ELABORE(options; réf_liste; [réf_critères]; [réf_copie]; [sans_doublon])

Simulates the Format Données Filtre Filtre élaboré menu option.

optionsWhether to filter in place or copy to another location. The possible values are:
1Filter the list in place
2Copy the list to another location
réf_listeThe location of the list to be filtered.
réf_critèresThe location of any filter criteria to be used. If this parameter is omitted no criteria will be applied.
réf_copieThe destination of the copied data. This is only used when operation is 2.
sans_doublonWhether to select unique records only. The possible values are:
FAUXDisplay all records that match the criteria.
VRAIDisplay only unique records that match the criteria.
If this parameter is omitted it defaults to FAUX.


FORMAT.DEPLACEMENT([pos_x]; [pos_y]; [réf])

Moves the currently selected object.

pos_xThe offset in points of the top-left corner of the object from the left edge of the cell. If this parameter is omitted it defaults to 0.
pos_yThe offset in points of the top-left corner of the object from the top edge of the cell. If this parameter is omitted it defaults to 0.
réfThe cell containing the top-left corner of the object. If this parameter is omitted it defaults to A1.


FORMAT.LEGENDE(no_position)

Changes the active chart legend placement.

no_positionThe placement of the legend. The possible values are:
1Bas
2Coin
3Haut
4Droite
5Gauche


FORMAT.NOMBRE(format_texte)

Simulates the Format Cellules dialog Nombre page.

format_texteThe number format to be used.


FORMAT.TEXTE([align_x]; [align_y]; [no_orientation]; [texte_auto]; [dimension_auto]; [afficher_légende]; [afficher_valeur]; [ajouter_retrait])

Formats the text in a text box or command button.

align_xThe horizontal alignment. The possible values are:
1Gauche
2Centré
3Droite
4Justifié
If this parameter is omitted the setting is not changed.
align_yThe vertical alignment. The possible values are:
1Haut
2Centré
3Bas
4Justifié
If this parameter is omitted the setting is not changed.
no_orientationThe text orientation (not currently implemented).
texte_autoResets data label text (not currently implemented).
dimension_autoResets the border around the text (not currently implemented).
afficher_légendeShows legend key for data labels (not currently implemented).
afficher_valeurShows values for data labels (not currently implemented).
ajouter_retraitUsed for Far East versions only (not currently implemented).


FORMULE(formule_texte; [référence])

Enters the specified formula in the specified reference. Any references in the formula must be in R1C1 format. The CONVERSION.FORMULE function can be used to convert references.

formule_texteThe formula to be inserted.
référenceThe reference where formula to be inserted. If this parameter is omitted it defaults to the cursor position on the active worksheet.


FORMULE.MATRICIELLE(formule_texte; [référence])

Enters the specified array formula in the specified reference. Any references in the formula must be in R1C1 format. The CONVERSION.FORMULE function can be used to convert references.

formule_texteThe formula to be inserted.
référenceThe reference where formula to be inserted. If this parameter is omitted it defaults to the current selection on the active worksheet.


GRAPHIQUE.ANNEAU(no_type; [supprimer_superposition])

Changes the active chart to a doughnut chart.

no_typeThe format to be applied to the chart. The possible values are:
1no data labels, not exploded
2data labels, not exploded
3no data labels, first segment exploded (not currently implemented)
4no data labels, all segments exploded (not currently implemented)
5data labels, not exploded
6data percentages, not exploded
7data labels and percentages, not exploded
supprimer_superpositionWhether to delete any overlays (not currently implemented).


GRILLE()

Simulates the Format Données Grille menu option.



HAUTEUR.LIGNE([hauteur]; [référence]; [standard]; [type_nom])

Simulates the Format Ligne menu options.

hauteurThe new height of the rows. The height is measured in points. This parameter is ignored if standard is VRAI or type_nom is specified. If this parameter is omitted the height of the specified rows is not changed.
référenceThe rows whose height is to be changed. If this parameter is omitted it defaults to the current selection on the active worksheet.
standardSpecifies whether the rows are to be set to the standard row height. The possible values are:
VRAIThe rows are set to the standard height.
FAUXThe rows are not set to the standard height.
If this parameter is omitted it defaults to FAUX.
type_nomSpecifies whether the rows are to be hidden, unhidden or automatically sized. This parameter is ignored if standard is VRAI. The possible values are:
1The rows are hidden.
2The rows are unhidden.
3The rows are set to the height of the highest displayed value.
If this parameter is omitted the rows will not be hidden, unhidden or auto-sized.


HISTOGRAMMES(no_type; [supprimer_superposition])

Changes the active chart to a column chart.

no_typeThe format to be applied to the chart. The possible values are:
1no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, not stacked, no series lines
2no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, not stacked, no series lines
3no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, stacked, no series lines (not currently implemented)
4no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, not stacked, no series lines
5no horizontal gridlines, no vertical gridlines, 100% y axis, no data labels, stacked, no series lines (not currently implemented)
6horizontal gridlines, no vertical gridlines, linear y axis, no data labels, not stacked, no series lines
7no horizontal gridlines, no vertical gridlines, linear y axis, data values, not stacked, no series lines
8no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, not stacked, no series lines
9no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, stacked, series lines (not currently implemented)
10no horizontal gridlines, no vertical gridlines, 100% y axis, no data labels, stacked, series lines (not currently implemented)
supprimer_superpositionWhether to delete any overlays (not currently implemented).


INSERER([no_décaler])

Simulates the Insérer Cellules menu option.

no_décalerThe way in which the cell insertion is to be processed. The possible values are:
1Décaler les cellules vers la droite
2Décaler les cellules vers le bas
3Ligne entière
4Colonne entière
If this parameter is omitted it defaults to 2.


INSERER.CLASSEUR([no_type])

Simulates the Insérer Feuille, Graphique and Macro menu options.

no_typeThe type of sheet that is to be added. The possible values are:
1A worksheet
2A chart
3A macro sheet
If this parameter is omitted it defaults to the type of the currently active sheet.


INSERER.TITRE([graphique]; [y_principal]; [x_principal]; [y_secondaire]; [x_secondaire])

Attaches default text to the active chart. The SELECTIONNER and FORMULE functions can be used to change the text.

graphiqueWhether to add a default chart title. The possible values are:
FAUXDelete any existing chart title.
VRAIAdd default chart title if one does not already exist.
If this parameter is omitted the chart title is not changed.
y_principalWhether to add a default primary y-axis title. The possible values are:
FAUXDelete any existing primary y-axis title.
VRAIAdd default primary y-axis title if one does not already exist.
If this parameter is omitted the primary y-axis title is not changed.
x_principalWhether to add a default primary x-axis title. The possible values are:
FAUXDelete any existing primary x-axis title.
VRAIAdd default primary x-axis title if one does not already exist.
If this parameter is omitted the primary x-axis title is not changed.
y_secondaireWhether to add a default secondary y-axis title (not currently implemented).
x_secondaireWhether to add a default secondary x-axis title (not currently implemented).


LARGEUR.COLONNE([no_largeur]; [référence]; [standard]; [no_type]; [no_larg_standard])

Simulates the Format Colonne menu options.

no_largeurThe new width of the columns. The width is measured in characters. This parameter is ignored if standard is VRAI or type_nom is specified. If this parameter is omitted the width of the specified columns is not changed.
référenceThe columns whose width is to be changed. If this parameter is omitted it defaults to the current selection on the active worksheet.
standardSpecifies whether the columns are to be set to the standard column width. The possible values are:
VRAIThe columns are set to the standard width.
FAUXThe columns are not set to the standard width.
If this parameter is omitted it defaults to FAUX.
no_typeSpecifies whether the columns are to be hidden, unhidden or automatically sized. This parameter is ignored if standard is VRAI. The possible values are:
1The columns are hidden.
2The columns are unhidden.
3The columns are set to the width of the longest displayed value.
If this parameter is omitted the columns will not be hidden, unhidden or auto-sized.
no_larg_standardSpecifies the value to be used for the standard width. The width is measured in characters. If this parameter is omitted the standard width is not changed.


LARGEUR.STANDARD([no_standard])

Simulates the Format Colonne Largeur Standard menu option.

no_standardThe new standard width. If this parameter is omitted then the standard width is not changed.


LEGENDE([valeur_logique])

Changes the active chart legend visibility.

valeur_logiqueWhether to show the legend. The possible values are:
FAUXDo not show the legend
VRAIDo show the legend
If this parameter is omitted it defaults to VRAI.


LIGNEH([no_col])

Scrolls the worksheet horizontally by the specified number of columns.

no_colThe number of columns to scroll. A negative number will scroll to the left. If this parameter is omitted it defaults to 1.


LIGNEV([no_lignes])

Scrolls the worksheet vertically by the specified number of rows.

no_lignesThe number of rows to scroll. A negative number will scroll towards the top. If this parameter is omitted it defaults to 1.


LIRE.CELLULE(no_type; [référence])

Returns information about the specified cell.

no_typeThe type of information to return. The possible values are:
1Absolute reference of the upper-left cell in reference, as text
2Row number of the top cell in reference
3Column number of the leftmost cell in reference
4Same as TYPE(référence)
5Contents of reference
6Formula in reference, as text
7Number format of the cell, as text
8Number indicating the cell's horizontal alignment
9Number indicating the left-border style assigned to the cell
10Number indicating the right-border style assigned to the cell
11Number indicating the top-border style assigned to the cell
12Number indicating the bottom-border style assigned to the cell
13Number from 0 to 18, indicating the pattern of the selected cell
14If the cell is locked, returns VRAI; otherwise, returns FAUX
15If the cell's formula is hidden, returns VRAI; otherwise, returns FAUX
16A two-item horizontal array containing the width of the active cell and a logical value indicating whether the cell's width is set to change as the standard width changes (VRAI) or is a custom width (FAUX)
17Row height of cell, in points
18Name of font, as text
19Size of font, in points
20If the cell is bold returns VRAI; otherwise returns FAUX
21If the cell is italic returns VRAI; otherwise returns FAUX
22If the cell is underlined returns VRAI; otherwise returns FAUX
23If the cell is struck out returns VRAI; otherwise returns FAUX
24Font color of cell, as a number in the range 1 to 56. If font color is automatic, returns 0
25If the cell is outlined returns VRAI; otherwise returns FAUX
26If the cell is shadowed returns VRAI; otherwise returns FAUX
32Name of the workbook and sheet containing the cell
33If the cell is formatted to wrap, returns VRAI; otherwise, returns FAUX
34Left-border color as a number in the range 1 to 56. If color is automatic, returns 0
35Right-border color as a number in the range 1 to 56. If color is automatic, returns 0
36Top-border color as a number in the range 1 to 56. If color is automatic, returns 0
37Bottom-border color as a number in the range 1 to 56. If color is automatic, returns 0
38Shade foreground color as a number in the range 1 to 56. If color is automatic, returns 0
39Shade background color as a number in the range 1 to 56. If color is automatic, returns 0
42The horizontal distance, measured in points, from the left edge of the active window to the left edge of the cell
43The vertical distance, measured in points, from the top edge of the active window to the top edge of the cell
44The horizontal distance, measured in points, from the left edge of the active window to the right edge of the cell
45The vertical distance, measured in points, from the top edge of the active window to the bottom edge of the cell
46If the cell contains a comment, returns VRAI; otherwise, returns FAUX
48If the cell contains a formula, returns VRAI; if a constant, returns FAUX
49If the cell is part of an array, returns VRAI; otherwise, returns FAUX
50Number indicating the cell's vertical alignment
53Contents of the cell as it is currently displayed, as text
57If the cell is superscript returns VRAI; otherwise returns FAUX
58Returns the font style of the cell as text
59Returns the number for the underline style
60If the cell is subscript returns VRAI; otherwise returns FAUX
66Returns the book name of the workbook containing the cell in the form BOOK1.XLS
référenceThe cell whose information is to be returned. If this parameter is omitted it defaults to the active cell.


LIRE.COMMENTAIRES([réf_cellule]; [car_départ]; [no_car])

Returns the text of a comment.

réf_celluleThe reference of the cell containing the comment. If this parameter is omitted it defaults to the active cell.
car_départThe position of the first character to be returned. If this parameter is omitted it defaults to 1.
no_carThe length of the text to be returned. If this parameter is omitted it defaults to the length of the comment.


LIRE.FORMULE(référence)

Returns the contents of a cell as a string. Any references in a formula will be returned in R1C1 format.

référenceThe cell whose contents are to be returned.


LIRE.NOM(nom_texte; [type_info])

Returns information about a name.

nom_texteA string containing the name.
type_infoThe type of information to be returned. The possible values are:
1Return the definition.
2Return VRAI if it is a local name, or FAUX if it is a global name.
If this parameter is omitted it defaults to 1.


LIRE.OBJET(no_type; [identificateur_objet]; [no_départ]; [nb_car]; [élément_index])

Returns information about the specified object.

no_typeThe type of information to return. The possible values are:
1object type as number:
1 Ligne
2 Rectangle
3 Ellipse
6 Zone de texte
7 Bouton de commande
11 Case à cocher
12 Bouton d'option
14 Étiquette
16 Toupie
17 Barre de défilement
18 Zone de liste
19 Zone de groupe
20 Zone de liste modifiable
2locked
3z-order
4top-left cell as R1C1 reference
5x-offset of top-left corner in points
6y-offset of top-left corner in points
7bottom-right cell as R1C1 reference
8x-offset of bottom-right corner in points
9y-offset of bottom-right corner in points
10reference of the macro as text
11object positioning as number:
1 Déplacer et dimensionner avec les cellules
2 Déplacer sans dimensionner avec les cellules
3 Ne pas déplacer ou dimensionner avec les cellules
12object text from start_num for count_num characters
13font name
14font size
15bold
16italic
17underline
18strikethrough
19outline
20shadow
21text color
22horizontal alignment as number:
1 Gauche
2 Centré
3 Droite
4 Justifié
23vertical alignment as number:
1 Haut
2 Centré
3 Bas
4 Justifié
26visible
48linked cell reference as text
49object id number
56enabled
62current value
63minimum value
64maximum value
65increment value
66page value
71list/combo entries
73input range reference as text
74dropdown lines
75draw 3d
identificateur_objetThe object identifier. If this parameter is omitted it defaults to the currently selected object on the active worksheet.
no_départThe text substring start position for type_num 12. If this parameter is omitted it defaults to 1.
nb_carThe text substring length for type_num 12. If this parameter is omitted it defaults to 255.
élément_indexThis parameter is not currently used.


MASQUER.CLASSEUR([texte_feuille]; [très_masqué])

Simulates the Format Feuille Masquer menu option.

texte_feuilleThe name of the sheet to hide. If this parameter is omitted it defaults to the currently active sheet.
très_masquéWhether to show the name of the hidden sheet in the Unhide dialog box. The possible values are:
VRAIDo not show the sheet name
FAUXShow the sheet name
If this parameter is omitted it defaults to FAUX.


MASQUER.OBJET([texte_identificateur_objet]; [masque_valeur_logique])

Hides or shows an object.

texte_identificateur_objetThe object to be hidden or shown. If this parameter is omitted the currently selected object is used.
masque_valeur_logiqueWhether the object is hidden. The possible values are:
FAUXThe object is shown
VRAIThe object is hidden
If this parameter is omitted it defaults to VRAI.


MESSAGE(valeur_logique; [texte])

Displays a message on the status bar.

valeur_logiqueWhether to display or hide messages. The possible values are:
VRAIDisplay a message on the status bar.
FAUXRemove any message from the status bar.
texteThe message to be displayed. If this parameter is omitted it defaults to an empty string.


MODIFIER.COULEUR(no_couleur; [valeur_rouge]; [valeur_vert]; [valeur_bleu])

Changes the color associated with a specific color number.

no_couleurA number from 1 to 56, indicating which color is to be changed.
valeur_rougeA number from 0 to 255, specifying the intensity of the red component. If this parameter is omitted the red component is not changed.
valeur_vertA number from 0 to 255, specifying the intensity of the green component. If this parameter is omitted the green component is not changed.
valeur_bleuA number from 0 to 255, specifying the intensity of the blue component. If this parameter is omitted the blue component is not changed.


MODIFIER.SELECTION(no_direction)

Simulates the Ctrl+arrow key combination.

no_directionThe direction in which to move the cursor. The possible values are:
1Gauche
2Droite
3Haut
4Bas


MODIFIER.SERIES([no_série]; [réf_nom]; [réf_x]; [réf_y]; [réf_z]; [ordre_traçage])

Adds or changes a series on the active chart.

no_sérieThe number of the series to be changed. If this parameter is zero or omitted then a new series is added.
réf_nomThe series name. If this parameter is omitted the name is not changed.
réf_xThe X categories or values reference. If this parameter is omitted the reference is not changed.
réf_yThe Y values reference. If this parameter is omitted the reference is not changed.
réf_zThe Z values reference (not currently implemented).
ordre_traçageThe order of this series on the chart (not currently implemented).


MOTIFS([amotif]; [aplan]; [afond])

Simulates the Format Cellules dialog Motifs page.

amotifThe number of the pattern to be applied. The possible values are:
0Aucun
1Solide
250% Gris
375% Gris
425% Gris
5Horizontale Rayure
6Verticale Rayure
7Diagonale Inverse Rayure
8Diagonale Rayure
9Diagonale Hachure Croisée
10Épaisse Diagonale Hachure Croisée
11Fine Horizontale Rayure
12Fine Verticale Rayure
13Fine Diagonale Inverse Rayure
14Fine Diagonale Rayure
15Fine Horizontale Hachure Croisée
16Fine Diagonale Hachure Croisée
1712,5% Gris
186,25% Gris
If this parameter is omitted the setting is not changed.
aplanThe number of the foreground color to be applied. The possible values are:
1 to 56One of the colors displayed in the Format Cellules dialog Motifs page
If this parameter is omitted the setting is not changed.
afondThe number of the background color to be applied. The possible values are:
1 to 56One of the colors displayed in the Format Cellules dialog Motifs page
If this parameter is omitted the setting is not changed.


MOTIFS([lauto]; [lstyle]; [lcoul]; [lép]; [flargeur]; [flongueur]; [ftype])

Changes the attributes of the selected line.

lautoThe line setting. The possible values are:
0Personnalisée
1Automatique
2Aucun
If this parameter is omitted the setting is not changed.
lstyleThe line style (not currently implemented).
lcoulThe line color. The possible values are:
1 to 56One of the colors displayed in the Format Cellules dialog Motifs page
If this parameter is omitted the setting is not changed.
lépThe line weight (not currently implemented).
flargeurThe arrowhead width (not currently implemented).
flongueurThe arrowhead length (not currently implemented).
ftypeThe arrowhead type. The possible values are:
1Aucun
2Ouvert
3Fermé
4Double ouvert
5Double fermé
If this parameter is omitted the setting is not changed.


MOTIFS([cauto]; [cstyle]; [ccoul]; [cép]; [ombré]; [aauto]; [amotif]; [aplan]; [afond]; [arrondis]; [nouvui])

Changes the attributes of the selected text box, rectangle or oval.

cautoThe border setting. The possible values are:
0Personnalisée
1Automatique
2Aucun
If this parameter is omitted the setting is not changed.
cstyleThe border style (not currently implemented).
ccoulThe border color. The possible values are:
1 to 56One of the colors displayed in the Format Cellules dialog Motifs page
If this parameter is omitted the setting is not changed.
cépThe border weight (not currently implemented).
ombréWhether to apply a shadow to the object (not currently implemented).
aautoThe area setting. The possible values are:
0Personnalisée
1Automatique
2Aucun
If this parameter is omitted the setting is not changed.
amotifThe area pattern (not currently implemented).
aplanThe area foreground color. The possible values are:
1 to 56One of the colors displayed in the Format Cellules dialog Motifs page
If this parameter is omitted the setting is not changed.
afondThe area background color (not currently implemented).
arrondisWhether to draw the object with rounded corners (not currently implemented).
nouvuiWhether to use the new or old user interface color scheme (not currently implemented).


MOTIFS([cauto]; [cstyle]; [ccoul]; [cép]; [ombré]; [aauto]; [amotif]; [aplan]; [afond]; [inv]; [sélectionner]; [nouv_rempli])

Changes the attributes of the selected chart plot areas, bars, columns, pie slices or text labels.

cautoThe border setting. The possible values are:
0Personnalisée
1Automatique
2Aucun
If this parameter is omitted the setting is not changed.
cstyleThe border style. The possible values are:
1Solide
2Discontinue
3Pointillé
4Tiret-point
5Tiret-point-point
6Foncé
7Moyenne
8Clair
If this parameter is omitted the setting is not changed.
ccoulThe border color. The possible values are:
1 to 56One of the colors displayed in the Format Cellules dialog Motifs page
If this parameter is omitted the setting is not changed.
cépThe border weight (not currently implemented).
ombréWhether to apply a shadow to the object (not currently implemented).
aautoThe area setting. The possible values are:
0Personnalisée
1Automatique
2Aucun
If this parameter is omitted the setting is not changed.
amotifThe area pattern (not currently implemented).
aplanThe area foreground color. The possible values are:
1 to 56One of the colors displayed in the Format Cellules dialog Motifs page
If this parameter is omitted the setting is not changed.
afondThe area background color (not currently implemented).
invWhether to invert the pattern for a negative value (not currently implemented).
sélectionnerWhether to apply changes to just this item or all similar items (not currently implemented).
nouv_rempliWhether to use the new or old user interface color scheme (not currently implemented).


MOTIFS([lauto]; [lstyle]; [lcoul]; [lép]; [mauto]; [mstyle]; [mplan]; [mfond]; [sélectionner]; [lissage])

Changes the attributes of the selected chart series line.

lautoThe line setting. The possible values are:
0Personnalisée
1Automatique
2Aucun
If this parameter is omitted the setting is not changed.
lstyleThe line style. The possible values are:
1Solide
2Discontinue
3Pointillé
4Tiret-point
5Tiret-point-point
6Foncé
7Moyenne
8Clair
If this parameter is omitted the setting is not changed.
lcoulThe line color. The possible values are:
1 to 56One of the colors displayed in the Format Cellules dialog Motifs page
If this parameter is omitted the setting is not changed.
lépThe line weight (not currently implemented).
mautoThe marker setting. The possible values are:
0Personnalisée
1Automatique
2Aucun
If this parameter is omitted the setting is not changed.
mstyleThe marker style. The possible values are:
1Carré
2Carreau
3Triangle
4X
5Étoile
6Point
7Tiret
8Cercle
9Croix
If this parameter is omitted the setting is not changed.
mplanThe marker foreground color. The possible values are:
1 to 56One of the colors displayed in the Format Cellules dialog Motifs page
If this parameter is omitted the setting is not changed.
mfondThe marker background color. The possible values are:
1 to 56One of the colors displayed in the Format Cellules dialog Motifs page
If this parameter is omitted the setting is not changed.
sélectionnerWhether to apply changes to just this item or all similar items (not currently implemented).
lissageWhether to smooth picture markers (not currently implemented).


NOMMER.CLASSEUR(ancien_nom; nouveau_nom)

Simulates the Format Feuille Renommer menu option.

ancien_nomThe sheet that is to be renamed.
nouveau_nomThe new name for the sheet.


NOMS([document_texte]; [no_type]; [texte])

Returns a horizontal array containing defined names.

document_texteThe name of the workbook containing the names. If this parameter is omitted it defaults to the active workbook.
no_typeThe type of name to retrieve. The possible values are:
1Visible names
2Hidden names
3All names
If this parameter is omitted it defaults to 1.
texteA template name that may contain wildcard characters. If this parameter is omitted all names will match.


NOUVEAU.DOCUMENT([no_type]; [séries_xy]; [ajouter])

Simulates the Fichier Nouveau menu option.

no_typeThe type of workbook to create. The possible values are:
omittedNew workbook with 1 worksheet of the same type as the active worksheet.
1New workbook with 1 worksheet.
2New workbook with 1 chart based on the current selection (not currently implemented).
3New workbook with 1 macro sheet.
4New workbook with 1 international macro sheet (not currently implemented).
5New workbook based on Classeur.xlt or default template.
6New workbook with 1 VB module (not currently implemented).
7New workbook with 1 dialog sheet (not currently implemented).
file nameNew workbook based on template file.
séries_xyHow to interpret selected data for a new chart (not currently implemented).
ajouterWhether to add the specified sheet to the current workbook (not currently implemented).


NUAGES.DE.POINTS(no_type; [supprimer_superposition])

Changes the active chart to a scatter (XY) chart.

no_typeThe format to be applied to the chart. The possible values are:
1markers, no lines, no horizontal gridlines, no vertical gridlines, linear y axis, linear x axis
2markers, straight lines, no horizontal gridlines, no vertical gridlines, linear y axis, linear x axis
3markers, no lines, horizontal gridlines, vertical gridlines, linear y axis, linear x axis
4markers, no lines, horizontal gridlines, no vertical gridlines, logarithmic y axis, linear x axis
5markers, no lines, horizontal gridlines, vertical gridlines, logarithmic y axis, logarithmic x axis
6no markers, curved lines, no horizontal gridlines, no vertical gridlines, linear y axis, linear x axis (not currently implemented)
supprimer_superpositionWhether to delete any overlays (not currently implemented).


OPTIONS.AFFICHAGE([formule]; [état]; [commentaires]; [affichage_info]; [no_objet]; [sauts_pages]; [formules]; [quadrillage]; [no_couleur]; [en-têtes]; [plan]; [zéros]; [défil_horiz]; [défil_vert]; [onglets_feuilles])

Changes the program, file or sheet view options.

formuleSpecifies whether the formula bar is displayed. The possible values are:
FAUXThe formula bar is not displayed
VRAIThe formula bar is displayed
If this parameter is omitted the setting is not changed.
étatSpecifies whether the status bar is displayed. The possible values are:
FAUXThe status bar is not displayed
VRAIThe status bar is displayed
If this parameter is omitted the setting is not changed.
commentairesSpecifies whether comments and indicators are displayed (not currently implemented).
affichage_infoSpecifies whether the info window is displayed (not currently implemented).
no_objetSpecifies how objects are displayed (not currently implemented).
sauts_pagesSpecifies whether page breaks are displayed (not currently implemented).
formulesSpecifies whether to display formulas or values in cells. The possible values are:
FAUXValues are displayed
VRAIFormulas are displayed
If this parameter is omitted the setting is not changed.
quadrillageSpecifies whether gridlines are displayed. The possible values are:
FAUXGridlines are not displayed
VRAIGridlines are displayed
If this parameter is omitted the setting is not changed.
no_couleurSpecifies the color to be used for drawing gridlines (not currently implemented).
en-têtesSpecifies whether row and column headings are displayed. The possible values are:
FAUXRow and column headings are not displayed
VRAIRow and column headings are displayed
If this parameter is omitted the setting is not changed.
planSpecifies whether outline symbols are displayed (not currently implemented).
zérosSpecifies whether zero values are displayed (not currently implemented).
défil_horizSpecifies whether the horizontal scroll bar is displayed. The possible values are:
FAUXThe horizontal scroll bar is not displayed
VRAIThe horizontal scroll bar is displayed
If this parameter is omitted the setting is not changed.
défil_vertSpecifies whether the vertical scroll bar is displayed. The possible values are:
FAUXThe vertical scroll bar is not displayed
VRAIThe vertical scroll bar is displayed
If this parameter is omitted the setting is not changed.
onglets_feuillesSpecifies whether the sheet tabs are displayed. The possible values are:
FAUXThe sheet tabs are not displayed
VRAIThe sheet tabs are displayed
If this parameter is omitted the setting is not changed.


OUVRIR(fichier_texte; [mise_à_jour]; [lecture_seule]; [format]; [mot_passe_prot]; [mot_passe_rés_écriture]; [ignore_lecture_seule_rec]; [fichier_origine]; [séparateur_personnalisé]; [ajouter]; [modifiable]; [accès_fichier]; [notification]; [convertisseur])

Simulates the Fichier Ouvrir menu option.

fichier_texteThe name of the file to be opened.
mise_à_jourWhether to update external references. The possible values are:
0Do not update any references
1Update external references
2Update remote references (not currently implemented)
3Update external and remote references (not currently implemented)
If this parameter is omitted and external references exist then a prompt will be displayed.
lecture_seuleWhether to open the file as read-only (not currently implemented).
formatThe character used as a delimiter for text files. The possible values are:
1Tabulation
2Virgule
3Espace
4Point-virgule
5Nothing
6Personnalisé (specified in the séparateur_personnalisé parameter)
If this parameter is omitted the text file delimiter will be determined from the file extension.
mot_passe_protThe password required to unprotect a file (not currently implemented).
mot_passe_rés_écritureThe password required to open a read-only file for writing (not currently implemented).
ignore_lecture_seule_recWhether to suppress the display of the read-only recommended message (not currently implemented).
fichier_origineThe operating system where the file originated (not currently implemented).
séparateur_personnaliséThe character used as a custom delimiter for text files.
ajouterWhether to add the specified file to the current workbook (not currently implemented).
modifiableWhether a template file should be opened in read-write mode (not currently implemented).
accès_fichierWhether to change the access of a currently open file (not currently implemented).
notificationWhether to send a message when a shared workbook becomes available (not currently implemented).
convertisseurOverrides the default file type (not currently implemented).


OUVRIR.DIALOGUE([filtre_fichier]; [texte_bouton]; [titre]; [filtre_index])

Returns a file name from the Fichier Ouvrir dialog box, or FAUX if Annuler is selected.

filtre_fichierOne or more file filters, separated by commas. If this parameter is omitted it defaults to "Tous les fichiers (*.*), *.*".
texte_boutonReplacement text for the Open button (not currently implemented).
titreReplacement text for the dialog box title. If this parameter is omitted the title is not changed.
filtre_indexThe index of the initial file filter. If this parameter is omitted it defaults to 1.


PAGEH([no_fenêtres])

Scrolls the worksheet horizontally by the specified number of pages.

no_fenêtresThe number of pages to scroll. A negative number will scroll to the left. If this parameter is omitted it defaults to 1.


PAGEV([no_fenêtres])

Scrolls the worksheet vertically by the specified number of pages.

no_fenêtresThe number of pages to scroll. A negative number will scroll towards the top. If this parameter is omitted it defaults to 1.


PALETTE.COULEURS(fichier_texte)

Copies the color palette from another file.

fichier_texteThe name of the file from which to copy the palette. The file must already be open. If this parameter is an empty string then the colors are reset to the default values.


POSITION([position_horizontale]; [renvoi_ligne]; [position_verticale]; [orientation]; [ajouter_retrait])

Simulates the Format Cellules dialog Position page.

position_horizontaleThe horizontal alignment to be used. The possible values are:
1Général
2Gauche
3Center
4Droite
5Recopier
6Justifier
7Centrer sur sélection
If this parameter is omitted the setting is not changed.
renvoi_ligneWhether to wrap the text in the cells. The possible values are:
FAUXThe text is not wrapped
VRAIThe text is wrapped
If this parameter is omitted the setting is not changed.
position_verticaleThe vertical alignment to be used. The possible values are:
1Haut
2Centré
3Bas
4Justifier
If this parameter is omitted the setting is not changed.
orientationNot currently implemented.
ajouter_retraitNot currently implemented.


PREMIER.PLAN()

Changes the order of the objects on the active worksheet by moving the currently selected object to the front.



PROPRIETES.BARRE.DEFILEMENT([valeur]; [min]; [max]; [inc]; [page]; [liaison]; [ombrage_3D])

Changes the properties of a scroll bar or spin control.

valeurThe current value of the control. If this parameter is omitted the value is not changed.
minThe minimum value of the control. If this parameter is omitted the value is not changed.
maxThe maximum value of the control. If this parameter is omitted the value is not changed.
incThe change to the current value when the arrow button is clicked. If this parameter is omitted the value is not changed.
pageThe change to the current value when the area either side of the scroll bar thumb is clicked. If this parameter is omitted the value is not changed.
liaisonThe cell that is updated by the control. If this parameter is omitted the link is not changed.
ombrage_3DWhether to draw the control with 3d shading. The possible values are:
FAUX2d
VRAI3d
If this parameter is omitted the setting is not changed.


PROPRIETES.CASE.A.COCHER([valeur]; [liaison]; [texte_touche_accès_rapide]; [texte_touche_accès_rapide2]; [ombrage_3D])

Changes the properties of a check box or option button control.

valeurThe value of the control. The possible values are:
FAUXNon activée
VRAIActivée
0Non activée
1Activée
2Grisée
If this parameter is omitted the value is not changed.
liaisonThe cell that is updated by the control. If this parameter is omitted the link is not changed.
texte_touche_accès_rapideThe accelerator key on a dialog sheet (not currently implemented).
texte_touche_accès_rapide2The second accelerator key on a dialog sheet (not currently implemented).
ombrage_3DWhether to draw the control with 3d shading. The possible values are:
FAUX2d
VRAI3d
If this parameter is omitted the setting is not changed.


PROPRIETES.ETIQUETTE([texte_touche_accès_rapide]; [texte_touche_accès_rapide2]; [ombrage_3d])

Changes the properties of a label or group box control.

texte_touche_accès_rapideThe accelerator key on a dialog sheet (not currently implemented).
texte_touche_accès_rapide2The second accelerator key on a dialog sheet (not currently implemented).
ombrage_3dWhether to draw the control with 3d shading. The possible values are:
FAUX2d
VRAI3d
If this parameter is omitted the setting is not changed.


PROPRIETES.OBJET([type_déplacement]; [imprimer_objet])

Changes the properties of an object.

type_déplacementHow the object is attached to the cells. The possible values are:
1Déplacer et dimensionner avec les cellules
2Déplacer sans dimensionner avec les cellules
3Ne pas déplacer ou dimensionner avec les cellules
If this parameter is omitted the setting is not changed.
imprimer_objetWhether the object can be printed. The possible values are:
FAUXThe object is not printed
VRAIThe object is printed
If this parameter is omitted the setting is not changed.


PROPRIETES.POLICE([police]; [style_police]; [taille]; [barré]; [exposant]; [indice]; [relief]; [ombrage]; [souligné]; [couleur]; [normal]; [fond]; [car_début]; [nb_car])

Simulates the Format Cellules dialog Police page or changes the font of the selected chart text.

policeThe name of the font to be used.
style_policeThe style to be used. The possible values are:
"Regular"Removes the bold and italic attributes.
"Gras"Sets the font to bold.
"Italique"Sets the font to italic.
"Gras Italique"Sets the font to bold and italic.
If this parameter is omitted the style is not changed.
tailleThe point size to be used. If this parameter is omitted the size is not changed.
barréSets the strikethrough attribute. The possible values are:
FAUXThe font does not have the strikethrough attribute
VRAIThe font has the strikethrough attribute
If this parameter is omitted the strikethrough attribute is not changed.
exposantNot currently implemented.
indiceNot currently implemented.
reliefNot currently implemented.
ombrageNot currently implemented.
soulignéThe underline style to be used. The possible values are:
0None
1Single
2Double (not currently implemented)
3Single accounting (not currently implemented)
4Double accounting (not currently implemented)
If this parameter is omitted the underline style is not changed.
couleurThe color to be used. The possible values are:
0Automatic
1 to 56One of the colors displayed in the Format Cellules Police dialog box
If this parameter is omitted the color is not changed.
normalNot currently implemented.
fondNot currently implemented.
car_débutNot currently implemented.
nb_carNot currently implemented.


PROPRIETES.ZONE.LISTE([plage]; [liaison]; [taille_déroul]; [sélection_multiple]; [ombrage_3d])

Changes the properties of a list box or combo box control.

plageThe input range from which to fill the list. If this parameter is omitted the setting is not changed.
liaisonThe cell that is updated by the control. If this parameter is omitted the link is not changed.
taille_déroulThe number of lines in the drop-down list of a combo box. If this parameter is omitted the setting is not changed.
sélection_multipleWhether to allow more than one list selection (not currently implemented).
ombrage_3dWhether to draw the control with 3d shading. The possible values are:
FAUX2d
VRAI3d
If this parameter is omitted the setting is not changed.


PROTECTION.CELLULE([verrouillage]; [masquage])

Simulates the Format Cellules dialog Protection page.

verrouillageWhether the cell should be locked when the sheet is protected. The possible values are:
FAUXThe cell is not locked
VRAIThe cell is locked
If this parameter is omitted the setting is not changed.
masquageWhether the cell formula should be hidden when the sheet is protected. The possible values are:
FAUXThe cell formula is not hidden
VRAIThe cell formula is hidden
If this parameter is omitted the setting is not changed.


PROTEGER.DOCUMENT([contenu]; [fenêtres]; [mot_de_passe]; [objets]; [scénarios])

Simulates the Format Feuille Protéger menu option.

contenuWhether to protect the locked cell contents. The possible values are:
VRAIThe locked cell contents are protected
FAUXThe locked cell contents are unprotected
If this parameter is omitted it defaults to VRAI.
fenêtresWhether to protect windows from being moved or sized (not currently implemented). The possible values are:
VRAIThe windows are protected
FAUXThe windows are unprotected
If this parameter is omitted it defaults to FAUX.
mot_de_passeAn optional case-sensitive password to protect or unprotect the document.
objetsWhether to protect the locked objects (not currently implemented). The possible values are:
VRAIThe locked objects are protected
FAUXThe locked objects are unprotected
If this parameter is omitted it defaults to VRAI.
scénariosWhether to protect the scenarios (not currently implemented). The possible values are:
VRAIThe scenarios are protected
FAUXThe scenarios are unprotected
If this parameter is omitted it defaults to VRAI.


QUADRILLAGE([x_princ]; [x_sec]; [y_princ]; [y_sec]; [z_princ]; [z_sec]; [effet_2D])

Changes the active chart gridlines.

x_princWhether to draw the X-axis major gridlines. The possible values are:
FAUXDo not draw the X-axis major gridlines.
VRAIDo draw the X-axis major gridlines.
If this parameter is omitted the setting is not changed.
x_secWhether to draw the X-axis minor gridlines (not currently implemented).
y_princWhether to draw the Y-axis major gridlines. The possible values are:
FAUXDo not draw the Y-axis major gridlines.
VRAIDo draw the Y-axis major gridlines.
If this parameter is omitted the setting is not changed.
y_secWhether to draw the Y-axis minor gridlines (not currently implemented).
z_princWhether to draw the Z-axis minor gridlines (not currently implemented).
z_secWhether to draw the Z-axis minor gridlines (not currently implemented).
effet_2DWhether to draw 2D gridlines on 3D charts (not currently implemented).


QUITTER()

Simulates the Fichier Quitter menu option.



RADAR(no_type; [supprimer_superposition])

Changes the active chart to a radar chart.

no_typeThe format to be applied to the chart. The possible values are:
1markers, no horizontal gridlines, linear y axis, not filled
2no markers, no horizontal gridlines, linear y axis, not filled
3no markers, no horizontal gridlines, no y axis, not filled
4no markers, horizontal gridlines, linear y axis, not filled
5no markers, horizontal gridlines, logarithmic y axis, not filled
6no markers, no horizontal gridlines, linear y axis, filled (not currently implemented)
supprimer_superpositionWhether to delete any overlays (not currently implemented).



RECHERCHER.PRECEDENT.SEL()

Finds the previous cell based on the current criteria.



RECHERCHER.SELECTION(texte; nb_ds; nb_à; nb_par; [nb_dir]; [maj_min])

Simulates the Modifier Chercher menu option.

texteThe text that you want to find.
nb_dsWhere you want to look for the text. The possible values are:
1Formules
2Valeurs
3Commentaires
nb_àWhether to match this text against all or part of a cell. The possible values are:
1Rechercher cellules entiers seulement
2Any part of the text in a cell
nb_parWhether to search by rows or by columns. The possible values are:
1Par ligne
2Par colonne
nb_dirWhether to search for the next or previous match. The possible values are:
1Suivant
2Précédent
If this parameter is omitted it defaults to 1.
maj_minWhether the search is case-sensitive. The possible values are:
VRAIThe search is case-sensitive
FAUXThe search is not case-sensitive
If this parameter is omitted it defaults to FAUX.


RECHERCHER.SUIVANT.SEL()

Finds the next cell based on the current criteria.



RECOPIER.BAS()

Simulates the Modifier Recopier En bas menu option.



RECOPIER.DROITE()

Simulates the Modifier Recopier À droite menu option.



RECOPIER.GAUCHE()

Simulates the Modifier Recopier À gauche menu option.



RECOPIER.HAUT()

Simulates the Modifier Recopier En haut menu option.



REFABS(réf_texte; réf)

Returns an absolute reference corresponding to an offset from another reference.

réf_texteThe offset specified in R1C1 format.
réfThe base reference.


REFREL(réf; réf_rel)

Returns a string containing an R1C1 reference that represents the offset of the first reference from the second.

réfThe target reference.
réf_relThe base reference.


REFTEXTE(texte; [a1])

Returns a reference corresponding to the specified text.

texteThe string containing the reference.
a1Specifies the style of the reference. The possible values are:
FAUXR1C1 style
VRAIA1 style
If this parameter is omitted it defaults to FAUX.


REMPLACER.CELLULE(texte_cherché; texte_remplacé; [comment]; [par]; [cellule_active]; [maj_min])

Simulates the Modifier Chercher/Remplacer menu option.

texte_cherchéThe text that you want to find.
texte_remplacéThe text to replace the found text with.
commentWhether to match the text against all or part of a cell. The possible values are:
1Rechercher cellules entiers seulement
2Any part of the text in a cell
If this parameter is omitted it defaults to 1.
parWhether to search by rows or by columns. The possible values are:
1Par ligne
2Par colonne
If this parameter is omitted it defaults to 1.
cellule_activeWhether to replace in just the current cell or in the whole sheet. The possible values are:
VRAIText in the active cell is replaced
FAUXText in the whole sheet is replaced
If this parameter is omitted it defaults to FAUX.
maj_minWhether the search is case-sensitive. The possible values are:
VRAIThe search is case-sensitive
FAUXThe search is not case-sensitive
If this parameter is omitted it defaults to the value last used.


REPERTOIRE([chemin_accès])

Returns the path of the current directory, and optionally allows you to change it.

chemin_accèsThe path to which you want to change the current directory. If this parameter is omitted the current directory is not changed. Note that in Windows CE the current directory is always the root directory and cannot be changed.


SECTEURS(no_type; [supprimer_superposition])

Changes the active chart to a pie chart.

no_typeThe format to be applied to the chart. The possible values are:
1no data labels, not exploded
2data labels, not exploded
3no data labels, first segment exploded (not currently implemented)
4no data labels, all segments exploded (not currently implemented)
5data labels, not exploded
6data percentages, not exploded
7data labels and percentages, not exploded
supprimer_superpositionWhether to delete any overlays (not currently implemented).


SEL.DERNIERE.CELLULE()

Simulates the Ctrl+End key combination.



SELECTION()

Returns a reference which represents the current selection on the active worksheet.



SELECTION.ATTEINDRE([référence]; [coin])

Simulates the Modifier Atteindre menu option.

référenceThe cells that are to be selected. If the sheet name is omitted then it defaults to the currently active sheet. If this parameter is omitted it defaults to the sheet and cells that were selected before the last goto command.
coinSpecifies whether the top-left corner of the selection is to be placed in the top-left corner of the window. The possible values are:
FAUXThe sheet is not scrolled to move the selection to the top-left corner of the window.
VRAIThe sheet is scrolled to move the selection to the top-left corner of the window.
If this parameter is omitted it defaults to FAUX.


SELECTIONNER([sélection]; [cellule_active])

Sets the selection and cursor cell on the active worksheet.



SELECTIONNER([identificateur_objet_texte]; [remplacer])

Selects an object on the active worksheet.

sélectionThe cells that are to be the selection. If this parameter is omitted the current selection is not changed.
cellule_activeThe cell that is to be the cursor cell. If this parameter is omitted it defaults to the top left cell in the selection.
identificateur_objet_texteThe object to be selected. If this parameter is omitted the current selection is not changed.
remplacerWhether to replace or add to the existing object selection (not currently implemented).


SELECTIONNER([élément_texte]; [point_unique])

Selects an object on the active chart.

élément_texteThe object to be selected. The possible values are:
"Chart"Entire chart
"Plot"Plot area
"Axis 1"Primary chart value axis
"Axis 2"Primary chart category axis
"Axis 3Secondary chart value axis or 3D chart series axis
"Axis 4"Secondary chart category axis
"Title"Chart title
"Text Axis 1"Primary chart value axis title
"Text Axis 2"Primary chart category axis title
"Text Axis 3"Primary chart series axis title
"Text n"nth floating text item
"Arrow n"nth arrow
"Gridline 1"Value axis major gridlines
"Gridline 2"Value axis minor gridlines
"Gridline 3"Category axis major gridlines
"Gridline 4"Category axis minor gridlines
"Gridline 5"Series axis major gridlines
"Gridline 6"Series axis minor gridlines
"Dropline 1"Primary chart droplines
"Dropline 2"Secondary chart droplines
"Hiloline 1"Primary chart hi-lo lines
"Hiloline 2"Secondary chart hi-lo lines
"UpBar1"Primary chart up bar
"UpBar2"Secondary chart up bar
"DownBar1"Primary chart down bar
"DownBar2"Secondary chart down bar
"Seriesline1"Primary chart series line
"Seriesline2"Secondary chart series line
"Floor"3D chart base
"Walls"3D chart back
"Corners"3D chart corners
"Sn"Series n
"SnPm"Series n point m data
"SnTm"Series n trend line m
"SnEm"Series n error bars m
"Text Sn"Series n text
"Text SnPm"Series n point m text
"Legend"Legend
"Legend Marker n"Legend marker n
"Legend Entry n"Legend entry n
If this parameter is omitted the current selection is not changed.
point_uniqueWhether to select a single point or the entire series (not currently implemented).


SELON.DOUBLECLIC([feuille_texte]; [macro_texte])

Specifies a macro to be run when a cell is double-clicked.

feuille_texteThe name of the sheet for which the macro is to be run. If this parameter is omitted then the macro will be run for all sheets.
macro_texteA string containing a defined name or R1C1 reference indicating the macro that is to be run. If this parameter is omitted then no macro will be run.


SELON.ENTREE([feuille_texte]; [macro_texte])

Specifies a macro to be run when data is entered.

feuille_texteThe name of the sheet for which the macro is to be run. If this parameter is omitted then the macro will be run for all sheets.
macro_texteA string containing a defined name or R1C1 reference indicating the macro that is to be run. If this parameter is omitted then no macro will be run.


SELON.FEUILLE([feuille_texte]; [macro_texte]; [valeur_logique_activation])

Specifies a macro to be run when a sheet is activated or deactivated.

feuille_texteThe name of the sheet for which the macro is to be run. If this parameter is omitted then the macro will be run for all sheets.
macro_texteA string containing a defined name or R1C1 reference indicating the macro that is to be run. If this parameter is omitted then no macro will be run.
valeur_logique_activationSpecifies whether the macro is to be run when the sheet is activated or deactivated. The possible values are:
VRAIThe macro will be run when the sheet is activated.
FAUXThe macro will be run when the sheet is deactivated.
If this parameter is omitted it defaults to VRAI.


SUPPRIMER.CLASSEUR([texte_feuille])

Simulates the Modifier Supprimer Feuille menu option.

texte_feuilleThe sheet that is to be deleted. If this parameter is omitted it defaults to the currently active sheet.


SUPPRIMER.FORMAT(format_texte)

Deletes the specified custom number format. Any cells using this format will be changed to use the Général format.

format_texteA string containing the format to be deleted.


SUPPRIMER.NOM(nom_texte)

Simulates the Insérer Nom Definir Supprimer menu option.

nom_texteA string containing the name to be deleted.


TRIER([orientation]; [clé_1]; [ordre_1]; [clé_2]; [ordre_2]; [clé_3]; [ordre_3]; [en_tête]; [perso]; [maj_min])

Simulates the Format Données Trier menu option.

orientationSpecifies whether to sort the rows or columns. The possible values are:
1Sort rows
2Sort columns
If this parameter is omitted it defaults to 1.
clé_1Specifies a reference to the first column or row to sort on. If this parameter is omitted it defaults to the first column or row in the selection.
ordre_1Specifies whether to sort the data in ascending or descending order. The possible values are:
1Croissant
2Décroissant
If this parameter is omitted it defaults to 1.
clé_2Specifies a reference to the second column or row to sort on. If this parameter is omitted then the second key is not used.
ordre_2Specifies whether to sort the data in ascending or descending order. The possible values are:
1Croissant
2Décroissant
If this parameter is omitted it defaults to 1.
clé_3Specifies a reference to the third column or row to sort on. If this parameter is omitted then the third key is not used.
ordre_3Specifies whether to sort the data in ascending or descending order. The possible values are:
1Croissant
2Décroissant
If this parameter is omitted it defaults to 1.
en_têteSpecifies whether the selected cells include a header row or column. The possible values are:
0Determine the presence of a header automatically
1There is a header
2There is no header
If this parameter is omitted it defaults to 2.
persoSpecifies whether to use a custom list for the first sort key. The possible values are:
1Use normal sort sequence
2Day short names
3Day long names
4Month short names
5Month long names
If this parameter is omitted it defaults to 1.
maj_minSpecifies whether the sort should be case-sensitive. The possible values are:
VRAIThe sort is case-sensitive
FAUXThe sort is not case-sensitive
If this parameter is omitted it defaults to FAUX.


TEXTEREF(référence, [a1])

Returns a string containing the specified reference.

référenceThe reference that is to be converted to text.
a1Specifies the style of the reference. The possible values are:
FAUXR1C1 style
VRAIA1 style
If this parameter is omitted it defaults to FAUX.


TOUCHE.ARRET(activer_valeur_logique; [réf_macro])

Specifies the action taken when the Escape key is pressed in a macro.

activer_valeur_logiqueWhether to interrupt the macro. The possible values are:
FAUXThe macro continues
VRAIThe macro is interrupted
réf_macroThe macro to be run when the Escape key is pressed (not currently implemented)


VALEUR.CIBLE(cellule_cible; valeur_cible; cellule_variable)

Simulates the Format Données Valeur cible menu option.

cellule_cibleThe cell that is required to be a certain value. It must be a single cell containing a formula that returns a numeric result.
valeur_cibleThe value that the target cell needs to reach.
cellule_variableThe cell whose value can be changed. It must be a single cell that either contains a number or is empty.


ZONE.TEXTE(ajouter_texte; [identificateur_objet_texte]; [no_départ]; [no_car])

Changes the text of an object.

ajouter_texteThe text that is to be added.
identificateur_objet_texteThe object identifier. If this parameter is omitted it defaults to the currently selected object on the active worksheet.
no_départThe start position in the existing text where the new text is to be inserted. If this parameter is omitted it defaults to 1.
no_carThe length of existing text that is to be replaced. If this parameter is omitted it defaults to the length of the existing text.


ZOOM([facteur_zoom])

Simulates the Format Feuille Zoom menu option.

facteur_zoomThe magnification option. The possible values are:
numberSet the zoom level to the specified number. The number must be between 10 and 400.
VRAISet the zoom level so that the current selection fills the window.
FAUXReset the zoom level to 100%
If this parameter is omitted it defaults to VRAI.