SpreadCE Help

Makro command Funktionen

[ ] indicates optional parameters

Makro command Funktionen

ABBRECHEN.TASTE(Aktivieren; [Makrobezug])

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

Aktivieren

Whether to interrupt the macro. The possible values are:

FALSCH	The macro continues
WAHR	The macro is interrupted

Makrobezug

The macro to be run when the Escape key is pressed (not currently implemented)

ABSPOS(Bezug_Text; Bezug)

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

Bezug_Text	The offset specified in R1C1 format.
Bezug	The base reference.

ACHSEN([Primär_x]; [Primär_y]; [Sekundär_x]; [Sekundär_y])

Changes the active chart axes.

Primär_x

Whether to draw the X-axis. The possible values are:

FALSCH	Do not draw the X-axis.
WAHR	Do draw the X-axis.

If this parameter is omitted the setting is not changed.

Primär_y

Whether to draw the Y-axis. The possible values are:

FALSCH	Do not draw the Y-axis.
WAHR	Do draw the Y-axis.

If this parameter is omitted the setting is not changed.

Sekundär_x

Whether to draw the secondary X-axis (not currently implemented).

Sekundär_y

Whether to draw the secondary Y-axis (not currently implemented).

AKTIVE.ZELLE()

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

AKTIVIEREN([Fenstertext], [Ausschnitt_Num])

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

Fenstertext

The workbook and/or sheet name. If this parameter is omitted then the active window is not changed.

Ausschnitt_Num

For a split window, specifies which pane is to be active. The possible values are:

1	Upper or upper left.
2	Upper right.
3	Lower or lower left.
4	Lower right.

If this parameter is omitted it then the active pane is not changed.

AKTIVIEREN.VORHER([Arbeitsmappe])

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

Arbeitsmappe

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

AKTIVIEREN.WEITER([Arbeitsmappe])

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

Arbeitsmappe

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

AKTIVE.ZELLE.ZEIGEN()

Scrolls the active cell into view.

ARBEITSMAPPE.AKTIVIEREN(Blattname)

Specifies the sheet that is to be the active worksheet.

Blattname

The sheet that is to be the active worksheet.

ARBEITSMAPPE.AUSBLENDEN([Blattname]; [Ausgeblendet])

Simulates the Format Blatt Ausblenden menu option.

Blattname

The name of the sheet to hide. If this parameter is omitted it defaults to the currently active sheet.

Ausgeblendet

Whether to show the name of the hidden sheet in the Unhide dialog box. The possible values are:

WAHR	Do not show the sheet name
FALSCH	Show the sheet name

If this parameter is omitted it defaults to FALSCH.

ARBEITSMAPPE.EINBLENDEN([Blattname])

Simulates the Format Blatt Einblenden menu option.

Blattname

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

ARBEITSMAPPE.EINFÜGEN([Typ])

Simulates the Einfügen Blatt, Diagramm and Makro menu options.

Typ

The type of sheet that is to be added. The possible values are:

1	A worksheet
2	A chart
3	A macro sheet

If this parameter is omitted it defaults to the type of the currently active sheet.

ARBEITSMAPPE.LÖSCHEN([Blattname])

Simulates the Bearbeiten Blatt Löschen menu option.

Blattname

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

ARBEITSMAPPE.NAMEN(Alter_Name; Neuer_Name)

Simulates the Format Blatt Umbenennen menu option.

Alter_Name	The sheet that is to be renamed.
Neuer_Name	The new name for the sheet.

ARBEITSMAPPE.NÄCHSTES()

Simulates the Ctrl+Page Down key combination.

ARBEITSMAPPE.VORHERIGES()

Simulates the Ctrl+Page Up key combination.

AUSRICHTUNG([Horiz]; [Zeilenumbruch]; [Vert]; [Richtung]; [Einzug_hinzufügen])

Simulates the Format Zellen dialog Ausrichtung page.

Horiz

The horizontal alignment to be used. The possible values are:

1	Standard
2	Links
3	Mitte
4	Rechts
5	Ausfüllen
6	Bündig
7	Spaltenzentriert

If this parameter is omitted the setting is not changed.

Zeilenumbruch

Whether to wrap the text in the cells. The possible values are:

FALSCH	The text is not wrapped
WAHR	The text is wrapped

If this parameter is omitted the setting is not changed.

Vert

The vertical alignment to be used. The possible values are:

1	Oben
2	Mitte
3	Unten
4	Bündig

If this parameter is omitted the setting is not changed.

Richtung

Not currently implemented.

Einzug_hinzufügen

Not currently implemented.

AUSSCHNEIDEN([Von_Bezug]; [Zu_Bezug])

Simulates the Bearbeiten Ausschneiden menu option.

Von_Bezug	The cells that are to be cut to the clipboard. If this parameter is omitted it defaults to the current selection on the active worksheet.
Zu_Bezug	The cells where the cut information is to be pasted. If this parameter is omitted then the cells are not pasted.

AUSWAHL()

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

AUSWERTEN(Formel)

Returns the result of evaluating a formula.

formula_text

The formula to be evaluated.

AUSWÄHLEN([Auswahl]; [Aktive_Zelle])

Sets the selection and cursor cell on the active worksheet.

Auswahl	The cells that are to be the selection. If this parameter is omitted the current selection is not changed.
Aktive_Zelle	The cell that is to be the cursor cell. If this parameter is omitted it defaults to the top left cell in the selection.

AUSWÄHLEN([Objektbezeichnung]; [Ersetzen])

Selects an object on the active worksheet.

Objektbezeichnung	The object to be selected. If this parameter is omitted the current selection is not changed.
Ersetzen	Whether to replace or add to the existing object selection (not currently implemented).

AUSWÄHLEN([Element]; [Einzelpunkte])

Selects an object on the active chart.

Element

The 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 3	Secondary 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.

Einzelpunkte

Whether to select a single point or the entire series (not currently implemented).

BEARBEITEN.LÖSCHEN([Verschieben_Zahl])

Simulates the Bearbeiten Löschen menu option.

shift_num

The way in which the cell deletion is to be processed. The possible values are:

1	Nach links verschieben.
2	Nach oben verschieben.
3	Ganze Zeile.
4	Ganze Spalte.

If this parameter is omitted it defaults to 2.

BEENDEN()

Simulates the Datei Beenden menu option.

BEI.BLATT([Blattname]; [Makro]; [Aktivieren])

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

Blattname

The 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.

Makro

A 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.

Aktivieren

Specifies whether the macro is to be run when the sheet is activated or deactivated. The possible values are:

WAHR	The macro will be run when the sheet is activated.
FALSCH	The macro will be run when the sheet is deactivated.

If this parameter is omitted it defaults to WAHR.

BEI.DOPPELKLICK([Blattname]; [Makro])

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

Blattname	The 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.
Makro	A 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.

BEI.EINGABE([Blattname]; [Makro])

Specifies a macro to be run when data is entered.

Blattname	The 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.
Makro	A 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.

BEZEICHNUNG.EIGENSCHAFTEN([Zugriffstaste]; [Zugriffstaste2]; [3D_Effekt])

Changes the properties of a label or group box control.

Zugriffstaste

The accelerator key on a dialog sheet (not currently implemented).

Zugriffstaste2

The second accelerator key on a dialog sheet (not currently implemented).

3D_Effekt

Whether to draw the control with 3d shading. The possible values are:

FALSCH	2d
WAHR	3d

If this parameter is omitted the setting is not changed.

BILDLAUF.EIGENSCHAFTEN([Wert]; [Min]; [Max]; [Inkrement]; [Seitenwechsel]; [Verknüpfung]; [3D_Effekt])

Changes the properties of a scroll bar or spin control.

Wert

The current value of the control. If this parameter is omitted the value is not changed.

Min

The minimum value of the control. If this parameter is omitted the value is not changed.

Max

The maximum value of the control. If this parameter is omitted the value is not changed.

Inkrement

The change to the current value when the arrow button is clicked. If this parameter is omitted the value is not changed.

Seitenwechsel

The 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.

Verknüpfung

The cell that is updated by the control. If this parameter is omitted the link is not changed.

3D_Effekt

Whether to draw the control with 3d shading. The possible values are:

FALSCH	2d
WAHR	3d

If this parameter is omitted the setting is not changed.

DATEI.BERECHNEN()

Causes the current worksheet to be recalculated.

DATEI.LÖSCHEN(Datei)

Deletes a file.

Datei

The name of the file to be deleted.

DATEI.SCHLIESSEN([Speichern]; [Weiterleiten])

Simulates the Datei Schließen menu option.

Speichern

Whether to save a changed file before closing it. The possible values are:

FALSCH	Do not save the file
WAHR	Save the file

If this parameter is omitted then the prompt is displayed.

Weiterleiten

Whether to route the file after closing it (not currently implemented).

DATEI.SCHÜTZEN([Inhalt]; [Fenster]; [Kennwort]; [Objekte]; [Szenarien])

Simulates the Format Blatt Schützen menu option.

Inhalt

Whether to protect the locked cell contents. The possible values are:

WAHR	The locked cell contents are protected
FALSCH	The locked cell contents are unprotected

If this parameter is omitted it defaults to WAHR.

Fenster

Whether to protect windows from being moved or sized (not currently implemented). The possible values are:

WAHR	The windows are protected
FALSCH	The windows are unprotected

If this parameter is omitted it defaults to FALSCH.

Kennwort

An optional case-sensitive password to protect or unprotect the document.

Objekte

Whether to protect the locked objects (not currently implemented). The possible values are:

WAHR	The locked objects are protected
FALSCH	The locked objects are unprotected

If this parameter is omitted it defaults to WAHR.

Szenarien

Whether to protect the scenarios (not currently implemented). The possible values are:

WAHR	The scenarios are protected
FALSCH	The scenarios are unprotected

If this parameter is omitted it defaults to WAHR.

DATEI.SPEICHERN.UNTER([Dateiname]; [Titel]; [Schaltfläche]; [Dateifilter]; [Filter_Index])

Returns a file name from the Datei Speichern Unter dialog box, or FALSCH if Abbrechen is selected.

Dateiname	The suggested file name. If this parameter is omitted it defaults to the name of the active file.
Titel	Replacement text for the dialog box title. If this parameter is omitted the title is not changed.
Schaltfläche	Replacement text for the Save button (not currently implemented).
Dateifilter	One or more file filters, separated by commas. If this parameter is omitted it defaults to "Alle Dateien (.), .".
Filter_Index	The index of the initial file filter. If this parameter is omitted it defaults to 1.

DATEI.ÖFFNEN([Dateifilter]; [Schaltfläche]; [Titel]; [Filter_Index])

Returns a file name from the Datei Öffnen dialog box, or FALSCH if Abbrechen is selected.

Dateifilter	One or more file filters, separated by commas. If this parameter is omitted it defaults to "Alle Dateien (.), .".
Schaltfläche	Replacement text for the Open button (not currently implemented).
Titel	Replacement text for the dialog box title. If this parameter is omitted the title is not changed.
Filter_Index	The index of the initial file filter. If this parameter is omitted it defaults to 1.

DATEIEN([Verzeichnistext])

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

Verzeichnistext

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

DATENBESCHRIFTUNG([Anzeigen]; [Auto_Text]; [Symbol])

Changes the active chart data labels.

Anzeigen

The type of label to show. The possible values are:

1	Kein
2	Wert anzeigen
3	Prozent anzeigen
4	Beschriftung anzeigen
5	Beschriftung und Prozent anzeigen

If this parameter is omitted the data labels are not changed.

Auto_Text

Whether to reset the data labels (not currently implemented).

Symbol

Whether to show the legend key next to the label (not currently implemented).

DATENREIHE.BEARBEITEN([Datenreihe]; [Name_Bezug]; [x_Bez]; [y_Bez]; [z_Bez]; [Darstellungsfolge])

Adds or changes a series on the active chart.

Datenreihe	The number of the series to be changed. If this parameter is zero or omitted then a new series is added.
Name_Bezug	The series name. If this parameter is omitted the name is not changed.
x_Bez	The X categories or values reference. If this parameter is omitted the reference is not changed.
y_Bez	The Y values reference. If this parameter is omitted the reference is not changed.
z_Bez	The Z values reference (not currently implemented).
Darstellungsfolge	The order of this series on the chart (not currently implemented).

DATENREIHE.BERECHNEN([Zeile_Spalte]; [Typ]; [Datum]; [Schrittweite]; [Endwert]; [Trend])

Simulates the Bearbeiten Ausfüllen Datenreihe menu option.

Zeile_Spalte

Indicates whether the series is in rows or columns. The possible values are:

1	Zeilen
2	Spalten

If this parameter is omitted it defaults depending on the shape of the current selection.

Typ

The way in which the series values change. The possible values are:

1	Linear
2	Geometrisch
3	Datum
4	Auto (not currently implemented)

If this parameter is omitted it defaults to 1.

Datum

The way in which the date values change. The possible values are:

1	Tag
2	Wochentag
3	Monat
4	Jahr

If this parameter is omitted it defaults to 1.

Schrittweite

The number used to add to or multiply by the series value. If this parameter is omitted it defaults to 1.

Endwert

The value at which to stop filling the series. If this parameter is omitted then the entire selection is filled.

Trend

Indicates whether to fill the series using trend values calculated from existing data. The possible values are:

FALSCH	Don't use trend values.
WAHR	Use trend values (not currently implemented).

If this parameter is omitted it defaults to FALSCH.

DGRÖSSE(Dateinum)

Returns a size of a file.

Dateinum

The file number that was returned by the DÖFFNEN function.

DLESEN(Dateinum; Anzahl_Zeichen)

Returns a string of characters from a file.

Dateinum	The file number that was returned by the DÖFFNEN function.
Anzahl_Zeichen	The number of characters to read.

DLESEN.ZEILE(Dateinum)

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

Dateinum

The file number that was returned by the DÖFFNEN function.

DOKUMENTE([Typ]; [Suchkrit])

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

Typ

Specifies whether to include add-in workbooks in the list. The possible values are:

1	List only open files that are not add-in workbooks.
2	List only open files that are add-in workbooks.
3	List all open files.

If this parameter is omitted it defaults to 1.

Suchkrit

A template name that may contain wildcard characters. If this parameter is omitted then all workbook names will be included.

DPOS(Dateinum; [Position])

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

Dateinum	The file number that was returned by the DÖFFNEN function.
Position	The location where the next read or write will occur.
	If this parameter is omitted the current position is not changed.

DSCHLIESSEN(Dateinum)

Closes a file that was previously opened by the DÖFFNEN function.

Dateinum

The file number that was returned by the DÖFFNEN function.

DSCHREIBEN(Dateinum; Text)

Writes a string of characters to a file.

Dateinum	The file number that was returned by the DÖFFNEN function.
Text	The text to be written.

DSCHREIBEN.ZEILE(Dateinum; Text)

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

Dateinum	The file number that was returned by the DÖFFNEN function.
Text	The text to be written.

DUPLIZIEREN()

Duplicates the currently selected object.

DÖFFNEN(Datei; [Zugriff_Num])

Opens a file for reading or writing. The return value is a file number that can be passed as a parameter to the DLESEN, DLESEN.ZEILE, DSCHREIBEN, DSCHREIBEN.ZEILE, DPOS, DGRÖSSE and DSCHLIESSEN functions.

Datei

The name of the file to open.

Zugriff_Num

The access required to the file. The possible values are:

1	Open the file for reading and writing. The file must already exist.
2	Open the file for reading only. The file must already exist.
3	Create 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.

ECHO([Wahrheitswert])

Controls screen updating while a macro is running.

Wahrheitswert

Whether to update the screen while the macro is running. The possible values are:

FALSCH	Do not update the screen
WAHR	Do update the screen

If this parameter is omitted the setting is toggled.

EINFÜGEN([Zu_Bezug])

Simulates the Bearbeiten Einfügen menu option.

Zu_Bezug

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

EINGABE(Hinweis; [Typ]; [Überschrift]; [Vorgabe]; [x_Position]; [y_Position]; [Hilfe_Bezug])

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

Hinweis

The message that you want displayed in the dialog box.

Typ

The 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):

0	Formel
1	Zahl
2	Text
4	Logisch
8	Verweis
16	Fehler
64	Array

If this parameter is omitted it defaults to 2.

Überschrift

The title to be used for the dialog box. If this parameter is omitted it defaults to "Eingabe".

Vorgabe

The 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.

x_Position

The 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).

y_Position

The 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).

Hilfe_Bezug

The 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).

ENDE.AUSWÄHLEN(Richtungsnum)

Simulates the Ctrl+arrow key combination.

Richtungsnum

The direction in which to move the cursor. The possible values are:

1	Links
2	Rechts
3	Oben
4	Unten

ERROR(Aktivieren; [Makrobezug])

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

Aktivieren

Whether to interrupt the macro. The possible values are:

FALSCH	The macro continues
WAHR	The macro is interrupted

Makrobezug

The macro to be run when an error occurs (not currently implemented)

FARBE.BEARBEITEN(Farbe; [Farbwert_Rot]; [Farbwert_Grün]; [Farbwert_Blau])

Changes the color associated with a specific color number.

Farbe	A number from 1 to 56, indicating which color is to be changed.
Farbwert_Rot	A number from 0 to 255, specifying the intensity of the red component. If this parameter is omitted the red component is not changed.
Farbwert_Grün	A number from 0 to 255, specifying the intensity of the green component. If this parameter is omitted the green component is not changed.
Farbwert_Blau	A number from 0 to 255, specifying the intensity of the blue component. If this parameter is omitted the blue component is not changed.

FARBPALETTE(Datei)

Copies the color palette from another file.

Datei

The 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.

FENSTER.FIXIEREN([Wahrheitswert]; [Spalte]; [Zeile])

Simulates the Format Fixieren menu option.

Wahrheitswert

Whether to freeze or unfreeze the panes. The possible values are:

FALSCH	Unfreeze the panes
WAHR	Freeze the panes

If this parameter is omitted the setting is toggled.

Spalte

The number of columns to be frozen. If this parameter is omitted all columns left of the cursor cell are frozen.

Zeile

The number of rows to be frozen. If this parameter is omitted all rows above the cursor cell are frozen.

FILTER([Feld]; [Kriterien1]; [Operator]; [Kriterien2])

Simulates the Format Daten Filter AutoFilter menu option.

Feld

The 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.

Kriterien1

A string specifying the criteria to be used. If this parameter is omitted any filter criteria are removed from the specified column.

Operator

The combination operation when multiple criteria are used. The possible values are:

1	Und
2	Oder

If this parameter is omitted the second criteria is not used.

Kriterien2

A string specifying the criteria to be used. If this parameter is omitted the second criteria is not used.

FILTER.ALLE.ANZEIGEN()

Simulates the Format Daten Filter Alle anzeigen menu option.

FORMAT.LEGENDE(Position)

Changes the active chart legend placement.

Position

The placement of the legend. The possible values are:

1	Unten
2	Ecke
3	Oben
4	Rechts
5	Links

FORMAT.LÖSCHEN(Formattext)

Deletes the specified custom number format. Any cells using this format will be changed to use the Standard format.

Formattext

A string containing the format to be deleted.

FORMAT.TEXT([x_Ausrichtung]; [y_Ausrichtung]; [Zentrierung]; [Auto_Text]; [Auto_Größe]; [Schlüssel_zeigen]; [Wert_zeigen]; [Einrücken])

Formats the text in a text box or command button.

x_Ausrichtung

The horizontal alignment. The possible values are:

1	Links
2	Mitte
3	Rechts
4	Bündig

If this parameter is omitted the setting is not changed.

y_Ausrichtung

The vertical alignment. The possible values are:

1	Oben
2	Mitte
3	Unten
4	Bündig

If this parameter is omitted the setting is not changed.

Zentrierung

The text orientation (not currently implemented).

Auto_Text

Resets data label text (not currently implemented).

Auto_Größe

Resets the border around the text (not currently implemented).

Schlüssel_zeigen

Shows legend key for data labels (not currently implemented).

Wert_zeigen

Shows values for data labels (not currently implemented).

Einrücken

Used for Far East versions only (not currently implemented).

FORMAT.VERSCHIEBEN([x_Position]; [y_Position]; [Bezug])

Moves the currently selected object.

x_Position	The 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.
y_Position	The 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.
Bezug	The cell containing the top-left corner of the object. If this parameter is omitted it defaults to A1.

FORMAT.ZAHLENFORMAT(Textformat)

Simulates the Format Zellen dialog Zahl page.

Textformat

The number format to be used.

FORMEL(Formel; [Bezug])

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

Formel	The formula to be inserted.
Bezug	The reference where formula to be inserted. If this parameter is omitted it defaults to the cursor position on the active worksheet.

FORMEL.AUSFÜLLEN(Formel; [Bezug])

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

Formel	The formula to be inserted.
Bezug	The reference where formula to be inserted. If this parameter is omitted it defaults to the current selection on the active worksheet.

FORMEL.GEHEZU([Bezug]; [Ecke])

Simulates the Bearbeiten Gehezu menu option.

Bezug

The 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.

Ecke

Specifies whether the top-left corner of the selection is to be placed in the top-left corner of the window. The possible values are:

FALSCH	The sheet is not scrolled to move the selection to the top-left corner of the window.
WAHR	The sheet is scrolled to move the selection to the top-left corner of the window.

If this parameter is omitted it defaults to FALSCH.

FORMEL.MFORMEL(Formel; [Bezug])

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

Formel	The formula to be inserted.
Bezug	The reference where formula to be inserted. If this parameter is omitted it defaults to the current selection on the active worksheet.

FORMEL.SUCHEN(Text; In; Ganze_Zellen; Reihenfolge; [Richtung]; [Groß_Klein])

Simulates the Bearbeiten Suchen menu option.

Text

The text that you want to find.

Where you want to look for the text. The possible values are:

1	Formel
2	Werte
3	Kommentare

Ganze_Zellen

Whether to match this text against all or part of a cell. The possible values are:

1	Nur ganze Zellen suchen
2	Any part of the text in a cell

Reihenfolge

Whether to search by rows or by columns. The possible values are:

1	Nach Zeilen
2	Nach Spalten

Richtung

Whether to search for the next or previous match. The possible values are:

1	Weiter
2	Vorher

If this parameter is omitted it defaults to 1.

Groß_Klein

Whether the search is case-sensitive. The possible values are:

WAHR	The search is case-sensitive
FALSCH	The search is not case-sensitive

If this parameter is omitted it defaults to FALSCH.

FORMEL.SUCHEN.UND.ERSETZEN(Suchtext; Ersatztext; [Ganze_Zellen]; [Reihenfolge]; [Aktive_Zelle]; [Groß_Klein])

Simulates the Bearbeiten Suchen/Ersetzen menu option.

Suchtext

The text that you want to find.

Ersatztext

The text to replace the found text with.

Ganze_Zellen

Whether to match the text against all or part of a cell. The possible values are:

1	Nur ganze Zellen suchen
2	Any part of the text in a cell

If this parameter is omitted it defaults to 1.

Reihenfolge

Whether to search by rows or by columns. The possible values are:

1	Nach Zeilen
2	Nach Spalten

If this parameter is omitted it defaults to 1.

Aktive_Zelle

Whether to replace in just the current cell or in the whole sheet. The possible values are:

WAHR	Text in the active cell is replaced
FALSCH	Text in the whole sheet is replaced

If this parameter is omitted it defaults to FALSCH.

Groß_Klein

Whether the search is case-sensitive. The possible values are:

WAHR	The search is case-sensitive
FALSCH	The search is not case-sensitive

If this parameter is omitted it defaults to the value last used.

FORMEL.SUCHEN.VORHER()

Finds the previous cell based on the current criteria.

FORMEL.SUCHEN.WEITER()

Finds the next cell based on the current criteria.

FORMEL.UMWANDELN(Formel; von_A1; [zu_A1]; [zu_Abs]; [Rel_zu_Bezug])

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

Formel

The formula to be converted.

von_A1

Whether references in the formula are in A1 or R1C1 format. The possible values are:

FALSCH	The references are in R1C1 format
WAHR	The references are in A1 format

zu_A1

Whether references in the formula are converted to A1 or R1C1 format. The possible values are:

FALSCH	The references are converted to R1C1 format
WAHR	The references are converted to A1 format

If this parameter is omitted the format is not changed.

zu_Abs

Whether references in the formula are converted to use absolute or relative reference type. The possible values are:

1	Absolute row, absolute column
2	Absolute row, relative column
3	Relative row, absolute column
4	Relative row, relative column

If this parameter is omitted the reference type is not changed.

Rel_zu_Bezug

The cell that R1C1 references are relative to. If this parameter is omitted it defaults to the cell containing this function.

FORMEL.ZUORDNEN(Bezug)

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

Bezug

The cell whose contents are to be returned.

GITTERNETZLINIEN([Rubrik_Haupt]; [Rubrik_Hilfs]; [Größe_Haupt]; [Größe_Hilfs]; [Serien_Haupt]; [Serien_Hilfs]; [2D_Effekt])

Changes the active chart gridlines.

Rubrik_Haupt

Whether to draw the X-axis major gridlines. The possible values are:

FALSCH	Do not draw the X-axis major gridlines.
WAHR	Do draw the X-axis major gridlines.

If this parameter is omitted the setting is not changed.

Rubrik_Hilfs

Whether to draw the X-axis minor gridlines (not currently implemented).

Größe_Haupt

Whether to draw the Y-axis major gridlines. The possible values are:

FALSCH	Do not draw the Y-axis major gridlines.
WAHR	Do draw the Y-axis major gridlines.

If this parameter is omitted the setting is not changed.

Größe_Hilfs

Whether to draw the Y-axis minor gridlines (not currently implemented).

Serien_Haupt

Whether to draw the Z-axis minor gridlines (not currently implemented).

Serien_Hilfs

Whether to draw the Z-axis minor gridlines (not currently implemented).

2D_Effekt

Whether to draw 2D gridlines on 3D charts (not currently implemented).

IN.DEN.HINTERGRUND()

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

IN.DEN.VORDERGRUND()

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

INHALTE.EINFÜGEN([Einfügen]; [Operation]; [Überspringen]; [Transponieren])

Simulates the Bearbeiten Inhalte Einfügen menu option.

Einfügen

The type of information to be pasted. The possible values are:

1	Alle
2	Formel
3	Wert
4	Formate
5	Kommentare
6	Alles außer Rahmen

If this parameter is omitted it defaults to 1.

Operation

The way in which the data being pasted is merged with existing data. The possible values are:

1	Kein
2	Addieren
3	Subtrahieren
4	Multiplizieren
5	Dividieren

If this parameter is omitted it defaults to 1.

Überspringen

Whether to ignore blank cells in the data being pasted. The possible values are:

FALSCH	Blank cells are included.
WAHR	Blank cells are skipped.

If this parameter is omitted it defaults to FALSCH.

Transponieren

Whether to transpose the data being pasted. The possible values are:

FALSCH	Data is not transposed.
WAHR	Data is transposed. (Not currently implemented)

If this parameter is omitted it defaults to FALSCH.

INHALTE.LÖSCHEN([Typ])

Simulates the Bearbeiten Löschen menu option.

Typ

The type of information to clear from the current selection on the active worksheet. The possible values are:

1	Clear all
2	Clear formats
3	Clear contents
4	Clear comments

If this parameter is omitted it defaults to 3.

KONTROLLKÄST.EIGENSCHAFTEN([Wert]; [Verknüpfung]; [Zugriffstaste]; [Zugriffstaste2]; [3D_Effekt])

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

Wert

The value of the control. The possible values are:

FALSCH	Nicht aktiviert
WAHR	Aktiviert
0	Nicht aktiviert
1	Aktiviert
2	Gemischt

If this parameter is omitted the value is not changed.

Verknüpfung

The cell that is updated by the control. If this parameter is omitted the link is not changed.

Zugriffstaste

The accelerator key on a dialog sheet (not currently implemented).

Zugriffstaste2

The second accelerator key on a dialog sheet (not currently implemented).

3D_Effekt

Whether to draw the control with 3d shading. The possible values are:

FALSCH	2d
WAHR	3d

If this parameter is omitted the setting is not changed.

KOPIEREN([Von_Bezug]; [Zu_Bezug])

Simulates the Bearbeiten Kopieren menu option.

Von_Bezug	The cells that are to be copied to the clipboard. If this parameter is omitted it defaults to the current selection on the active worksheet.
Zu_Bezug	The cells where the copied information is to be pasted. If this parameter is omitted then the cells are not pasted.

LEGENDE([Wahrheitswert])

Changes the active chart legend visibility.

Wahrheitswert

Whether to show the legend. The possible values are:

FALSCH	Do not show the legend
WAHR	Do show the legend

If this parameter is omitted it defaults to WAHR.

LETZTE.ZELLE.AUSWÄHLEN()

Simulates the Ctrl+End key combination.

LINKS.AUSFÜLLEN()

Simulates the Bearbeiten Ausfüllen Links menu option.

LISTENFELD.EIGENSCHAFTEN([Bereich]; [Verknüpfung]; [Drop_Länge]; [Mehrfach_Markierung]; [3D_Effekt])

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

Bereich

The input range from which to fill the list. If this parameter is omitted the setting is not changed.

Verknüpfung

The cell that is updated by the control. If this parameter is omitted the link is not changed.

Drop_Länge

The number of lines in the drop-down list of a combo box. If this parameter is omitted the setting is not changed.

Mehrfach_Markierung

Whether to allow more than one list selection (not currently implemented).

3D_Effekt

Whether to draw the control with 3d shading. The possible values are:

FALSCH	2d
WAHR	3d

If this parameter is omitted the setting is not changed.

MASKE()

Simulates the Format Daten Maske menu option.

MELDUNG(Wahrheitswert; [Text])

Displays a message on the status bar.

Wahrheitswert

Whether to display or hide messages. The possible values are:

WAHR	Display a message on the status bar.
FALSCH	Remove any message from the status bar.

Text

The message to be displayed. If this parameter is omitted it defaults to an empty string.

MUSTER([FMuster]; [FVgrd]; [FHgrd])

Simulates the Format Zellen dialog Muster page.

FMuster

The number of the pattern to be applied. The possible values are:

0	Keine
1	Uni
2	50% Grau
3	75% Grau
4	25% Grau
5	Horizontal Gestreift
6	Vertikal Gestreift
7	Umgekehrt Diagonal Gestreift
8	Diagonal Gestreift
9	Diagonal Kariert
10	Dick Diagonal Kariert
11	Dünn Horizontal Gestreift
12	Dünn Vertikal Gestreift
13	Dünn Umgekehrt Diagonal Gestreift
14	Dünn Diagonal Gestreift
15	Dünn Horizontal Kariert
16	Dünn Diagonal Kariert
17	12,5% Grau
18	6,25% Grau

If this parameter is omitted the setting is not changed.

FVgrd

The number of the foreground color to be applied. The possible values are:

1 to 56

One of the colors displayed in the Format Zellen dialog Muster page

If this parameter is omitted the setting is not changed.

FHgrd

The number of the background color to be applied. The possible values are:

1 to 56

One of the colors displayed in the Format Zellen dialog Muster page

If this parameter is omitted the setting is not changed.

MUSTER([SAut]; [SArt]; [SFarbe]; [SStark]; [PfBreit]; [PfLang]; [PfAusf])

Changes the attributes of the selected line.

SAut

The line setting. The possible values are:

0	Benutzerdefiniert
1	Automatisch
2	Kein

If this parameter is omitted the setting is not changed.

SArt

The line style (not currently implemented).

SFarbe

The line color. The possible values are:

1 to 56

One of the colors displayed in the Format Zellen dialog Muster page

If this parameter is omitted the setting is not changed.

SStark

The line weight (not currently implemented).

PfBreit

The arrowhead width (not currently implemented).

PfLang

The arrowhead length (not currently implemented).

PfAusf

The arrowhead type. The possible values are:

1	Kein
2	Öffnen
3	Geschlossen
4	Doppelt Öffnen
5	Doppelt Geschlossen

If this parameter is omitted the setting is not changed.

MUSTER([RAut]; [RArt]; [RFarbe]; [RStark]; [Schatten]; [FAut]; [FMuster]; [FVgrd]; [FHgrd]; [Abgerundet]; [Neu])

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

RAut

The border setting. The possible values are:

0	Benutzerdefiniert
1	Automatisch
2	Kein

If this parameter is omitted the setting is not changed.

RArt

The border style (not currently implemented).

RFarbe

The border color. The possible values are:

1 to 56

One of the colors displayed in the Format Zellen dialog Muster page

If this parameter is omitted the setting is not changed.

RStark

The border weight (not currently implemented).

Schatten

Whether to apply a shadow to the object (not currently implemented).

FAut

The area setting. The possible values are:

0	Benutzerdefiniert
1	Automatisch
2	Kein

If this parameter is omitted the setting is not changed.

FMuster

The area pattern (not currently implemented).

FVgrd

The area foreground color. The possible values are:

1 to 56

One of the colors displayed in the Format Zellen dialog Muster page

If this parameter is omitted the setting is not changed.

FHgrd

The area background color (not currently implemented).

Abgerundet

Whether to draw the object with rounded corners (not currently implemented).

Neu

Whether to use the new or old user interface color scheme (not currently implemented).

MUSTER([RAut]; [RArt]; [RFarbe]; [RStark]; [Schatten]; [FAut]; [FMuster]; [FVgrd]; [FHgrd]; [Umkehr]; [Zuweisen]; [Neu_Füll])

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

RAut

The border setting. The possible values are:

0	Benutzerdefiniert
1	Automatisch
2	Kein

If this parameter is omitted the setting is not changed.

RArt

The border style. The possible values are:

1	Uni
2	Gestrichelt
3	Punkt
4	Strichpunkt
5	Strichpunkt-Punkt
6	Dunkel
7	Mittel
8	Hell

If this parameter is omitted the setting is not changed.

RFarbe

The border color. The possible values are:

1 to 56

One of the colors displayed in the Format Zellen dialog Muster page

If this parameter is omitted the setting is not changed.

RStark

The border weight (not currently implemented).

Schatten

Whether to apply a shadow to the object (not currently implemented).

FAut

The area setting. The possible values are:

0	Benutzerdefiniert
1	Automatisch
2	Kein

If this parameter is omitted the setting is not changed.

FMuster

The area pattern (not currently implemented).

FVgrd

The area foreground color. The possible values are:

1 to 56

One of the colors displayed in the Format Zellen dialog Muster page

If this parameter is omitted the setting is not changed.

FHgrd

The area background color (not currently implemented).

Umkehr

Whether to invert the pattern for a negative value (not currently implemented).

Zuweisen

Whether to apply changes to just this item or all similar items (not currently implemented).

Neu_Füll

Whether to use the new or old user interface color scheme (not currently implemented).

MUSTER([SAut]; [SArt]; [SFarbe]; [SStark]; [PAut]; [PAuszeich]; [PVgrd]; [PHgrd]; [Zuweisen]; [Glätten])

Changes the attributes of the selected chart series line.

SAut

The line setting. The possible values are:

0	Benutzerdefiniert
1	Automatisch
2	Kein

If this parameter is omitted the setting is not changed.

SArt

The line style. The possible values are:

1	Uni
2	Gestrichelt
3	Punkt
4	Strichpunkt
5	Strichpunkt-Punkt
6	Dunkel
7	Mittel
8	Hell

If this parameter is omitted the setting is not changed.

SFarbe

The line color. The possible values are:

1 to 56

One of the colors displayed in the Format Zellen dialog Muster page

If this parameter is omitted the setting is not changed.

SStark

The line weight (not currently implemented).

PAut

The marker setting. The possible values are:

0	Benutzerdefiniert
1	Automatisch
2	Kein

If this parameter is omitted the setting is not changed.

PAuszeich

The marker style. The possible values are:

1	Quadrat
2	Diamant
3	Dreieck
4	X
5	Stern
6	Punkt
7	Strich
8	Kreis
9	Plus

If this parameter is omitted the setting is not changed.

PVgrd

The marker foreground color. The possible values are:

1 to 56

One of the colors displayed in the Format Zellen dialog Muster page

If this parameter is omitted the setting is not changed.

PHgrd

The marker background color. The possible values are:

1 to 56

One of the colors displayed in the Format Zellen dialog Muster page

If this parameter is omitted the setting is not changed.

Zuweisen

Whether to apply changes to just this item or all similar items (not currently implemented).

Glätten

Whether to smooth picture markers (not currently implemented).

MUSTER.BALKEN(Typ; [Überlagerung_löschen])

Changes the active chart to a bar chart.

Typ

The format to be applied to the chart. The possible values are:

1	no horizontal gridlines, no vertical gridlines, linear x axis, no data labels, not stacked, no series lines
2	no horizontal gridlines, no vertical gridlines, linear x axis, no data labels, not stacked, no series lines
3	no horizontal gridlines, no vertical gridlines, linear x axis, no data labels, stacked, no series lines (not currently implemented)
4	no horizontal gridlines, no vertical gridlines, linear x axis, no data labels, not stacked, no series lines
5	no horizontal gridlines, no vertical gridlines, 100% x axis, no data labels, stacked, no series lines (not currently implemented)
6	no horizontal gridlines, vertical gridlines, linear x axis, no data labels, not stacked, no series lines
7	no horizontal gridlines, no vertical gridlines, linear x axis, data values, not stacked, no series lines
8	no horizontal gridlines, no vertical gridlines, linear x axis, no data labels, not stacked, no series lines
9	no horizontal gridlines, no vertical gridlines, linear x axis, no data labels, stacked, series lines (not currently implemented)
10	no horizontal gridlines, no vertical gridlines, 100% x axis, no data labels, stacked, series lines (not currently implemented)

Überlagerung_löschen

Whether to delete any overlays (not currently implemented).

MUSTER.FLÄCHEN(Typ; [Überlagerung_löschen])

Changes the active chart to an area chart.

Typ

The format to be applied to the chart. The possible values are:

1	no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, no drop lines
2	no horizontal gridlines, no vertical gridlines, 100% y axis, no data labels, no drop lines (not currently implemented)
3	no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, drop lines (not currently implemented)
4	horizontal gridlines, vertical gridlines, linear y axis, no data labels, no drop lines
5	no horizontal gridlines, no vertical gridlines, linear y axis, data labels, no drop lines

Überlagerung_löschen

Whether to delete any overlays (not currently implemented).

MUSTER.KREIS(Typ; [Überlagerung_löschen])

Changes the active chart to a pie chart.

Typ

The format to be applied to the chart. The possible values are:

1	no data labels, not exploded
2	data labels, not exploded
3	no data labels, first segment exploded (not currently implemented)
4	no data labels, all segments exploded (not currently implemented)
5	data labels, not exploded
6	data percentages, not exploded
7	data labels and percentages, not exploded

Überlagerung_löschen

Whether to delete any overlays (not currently implemented).

MUSTER.LINIEN(Typ; [Überlagerung_löschen])

Changes the active chart to a line chart.

Typ

The format to be applied to the chart. The possible values are:

1	markers, straight lines, no horizontal gridlines, no vertical gridlines, linear y axis, no hi-lo lines
2	no markers, straight lines, no horizontal gridlines, no vertical gridlines, linear y axis, no hi-lo lines
3	markers, no lines, no horizontal gridlines, no vertical gridlines, linear y axis, no hi-lo lines
4	markers, straight lines, horizontal gridlines, no vertical gridlines, linear y axis, no hi-lo lines
5	markers, straight lines, horizontal gridlines, vertical gridlines, linear y axis, no hi-lo lines
6	markers, straight lines, horizontal gridlines, no vertical gridlines, logarithmic y axis, no hi-lo lines
7	markers, no lines, no horizontal gridlines, no vertical gridlines, linear y axis, hi-lo lines (not currently implemented)
8	high-low-close stock chart (not currently implemented)
9	open-high-low-close stock chart (not currently implemented)
10	no markers, curved lines, no horizontal gridlines, no vertical gridlines, linear y axis, no hi-lo lines (not currently implemented)

Überlagerung_löschen

Whether to delete any overlays (not currently implemented).

MUSTER.NETZ(Typ; [Überlagerung_löschen])

Changes the active chart to a radar chart.

Typ

The format to be applied to the chart. The possible values are:

1	markers, no horizontal gridlines, linear y axis, not filled
2	no markers, no horizontal gridlines, linear y axis, not filled
3	no markers, no horizontal gridlines, no y axis, not filled
4	no markers, horizontal gridlines, linear y axis, not filled
5	no markers, horizontal gridlines, logarithmic y axis, not filled
6	no markers, no horizontal gridlines, linear y axis, filled (not currently implemented)

Überlagerung_löschen

Whether to delete any overlays (not currently implemented).

MUSTER.PUNKT(Typ; [Überlagerung_löschen])

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

Typ

The format to be applied to the chart. The possible values are:

1	markers, no lines, no horizontal gridlines, no vertical gridlines, linear y axis, linear x axis
2	markers, straight lines, no horizontal gridlines, no vertical gridlines, linear y axis, linear x axis
3	markers, no lines, horizontal gridlines, vertical gridlines, linear y axis, linear x axis
4	markers, no lines, horizontal gridlines, no vertical gridlines, logarithmic y axis, linear x axis
5	markers, no lines, horizontal gridlines, vertical gridlines, logarithmic y axis, logarithmic x axis
6	no markers, curved lines, no horizontal gridlines, no vertical gridlines, linear y axis, linear x axis (not currently implemented)

Überlagerung_löschen

Whether to delete any overlays (not currently implemented).

MUSTER.RING(Typ; [Überlagerung_löschen])

Changes the active chart to a doughnut chart.

Typ

The format to be applied to the chart. The possible values are:

1	no data labels, not exploded
2	data labels, not exploded
3	no data labels, first segment exploded (not currently implemented)
4	no data labels, all segments exploded (not currently implemented)
5	data labels, not exploded
6	data percentages, not exploded
7	data labels and percentages, not exploded

Überlagerung_löschen

Whether to delete any overlays (not currently implemented).

MUSTER.SÄULEN(Typ; [Überlagerung_löschen])

Changes the active chart to a column chart.

Typ

The format to be applied to the chart. The possible values are:

1	no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, not stacked, no series lines
2	no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, not stacked, no series lines
3	no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, stacked, no series lines (not currently implemented)
4	no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, not stacked, no series lines
5	no horizontal gridlines, no vertical gridlines, 100% y axis, no data labels, stacked, no series lines (not currently implemented)
6	horizontal gridlines, no vertical gridlines, linear y axis, no data labels, not stacked, no series lines
7	no horizontal gridlines, no vertical gridlines, linear y axis, data values, not stacked, no series lines
8	no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, not stacked, no series lines
9	no horizontal gridlines, no vertical gridlines, linear y axis, no data labels, stacked, series lines (not currently implemented)
10	no horizontal gridlines, no vertical gridlines, 100% y axis, no data labels, stacked, series lines (not currently implemented)

Überlagerung_löschen

Whether to delete any overlays (not currently implemented).

NAMEN([Datei]; [Typ]; [Suchkrit])

Returns a horizontal array containing defined names.

Datei

The name of the workbook containing the names. If this parameter is omitted it defaults to the active workbook.

Typ

The type of name to retrieve. The possible values are:

1	Visible names
2	Hidden names
3	All names

If this parameter is omitted it defaults to 1.

Suchkrit

A template name that may contain wildcard characters. If this parameter is omitted all names will match.

NAMEN.FESTLEGEN(Name; [Bezug]; [Makrotyp]; [Shortcut]; [Ausblenden]; [Kategorie]; [Lokal])

Simulates the Einfügen Namen Festlegen Einfügen menu option.

Name

A string containing the name to be defined.

Bezug

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.

Makrotyp

The type of macro that this name refers to (not currently implemented).

Shortcut

The shortcut key used to activate a command macro. If this parameter is omitted no shortcut key is assigned.

Ausblenden

Whether the name is to be hidden in the name definition list. The possible values are:

FALSCH	Show the name in the list.
WAHR	Do not show the name in the list.

If this parameter is omitted it defaults to FALSCH.

Kategorie

Identifies the category of a custom function (not currently implemented).

Lokal

Whether the name is to local to the active sheet. The possible values are:

FALSCH	The name is defined as global.
WAHR	The name is defined as local.

If this parameter is omitted it defaults to FALSCH.

NAMEN.LÖSCHEN(Name)

Simulates the Einfügen Namen Festlegen Löschen menu option.

Name	A string containing the name to be deleted.

NAMEN.ZUORDNEN(Name; [Infotyp])

Returns information about a name.

Name

A string containing the name.

Infotyp

The type of information to be returned. The possible values are:

1	Return the definition.
2	Return WAHR if it is a local name, or FALSCH if it is a global name.

If this parameter is omitted it defaults to 1.

NEU([Typ]; [XY_Reihen]; [Wahrheitswert])

Simulates the Datei Neu menu option.

Typ

The type of workbook to create. The possible values are:

omitted	New workbook with 1 worksheet of the same type as the active worksheet.
1	New workbook with 1 worksheet.
2	New workbook with 1 chart based on the current selection (not currently implemented).
3	New workbook with 1 macro sheet.
4	New workbook with 1 international macro sheet (not currently implemented).
5	New workbook based on Mappe.xlt or default template.
6	New workbook with 1 VB module (not currently implemented).
7	New workbook with 1 dialog sheet (not currently implemented).
file name	New workbook based on template file.

XY_Reihen

How to interpret selected data for a new chart (not currently implemented).

Wahrheitswert

Whether to add the specified sheet to the current workbook (not currently implemented).

NEUBERECHNEN()

Causes all worksheets to be recalculated.

NOTIZ([Text]; [Zellbezug]; [Erstes_Zeichen]; [Anzahl_Zeichen])

Simulates the Einfügen Kommentar menu option.

Text	The text that is to be added. If this parameter is omitted it defaults to an empty string.
Zellbezug	The cell where the comment is to be inserted. If this parameter is omitted it defaults to the active cell.
Erstes_Zeichen	The start position in an existing comment where the new text is to be inserted. If this parameter is omitted it defaults to 1.
Anzahl_Zeichen	The 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.

NOTIZ.ZUORDNEN([Zellbezug]; [Erstes_Zeichen]; [Anzahl_Zeichen])

Returns the text of a comment.

Zellbezug	The reference of the cell containing the comment. If this parameter is omitted it defaults to the active cell.
Erstes_Zeichen	The position of the first character to be returned. If this parameter is omitted it defaults to 1.
Anzahl_Zeichen	The length of the text to be returned. If this parameter is omitted it defaults to the length of the comment.

OBEN.AUSFÜLLEN()

Simulates the Bearbeiten Ausfüllen Oben menu option.

OBJEKT.AKTIVIEREN([Objektbezeichnung]; [Aktivieren])

Specifies whether an object should respond to mouse clicks.

Objektbezeichnung

The object to be enabled or disabled. If this parameter is omitted the currently selected object is used.

Aktivieren

Whether the object is enabled. The possible values are:

WAHR	The object is enabled.
FALSCH	The object is disabled.

If this parameter is omitted the setting is not changed.

OBJEKT.AUSBLENDEN([Objektbezeichnung]; [Ausblenden])

Hides or shows an object.

Objektbezeichnung

The object to be hidden or shown. If this parameter is omitted the currently selected object is used.

Ausblenden

Whether the object is hidden. The possible values are:

FALSCH	The object is shown
WAHR	The object is hidden

If this parameter is omitted it defaults to WAHR.

OBJEKT.EIGENSCHAFTEN([Positionstyp]; [Objekt_drucken])

Changes the properties of an object.

Positionstyp

How the object is attached to the cells. The possible values are:

1	Von Zellposition und -größe abhängig
2	Nur von Zellposition abhängig
3	Von Zellposition und -größe unabhängig

If this parameter is omitted the setting is not changed.

Objekt_drucken

Whether the object can be printed. The possible values are:

FALSCH	The object is not printed
WAHR	The object is printed

If this parameter is omitted the setting is not changed.

OBJEKT.ERSTELLEN(Objekt; Bezug1; [x_Pos1]; [y_Pos1]; Bezug2; [x_Pos2]; [y_Pos2]; [Text]; [Ausfüllen]; [Bearbeitung])

Simulates the Einfügen Zeichnungsobjekt and Einfügen Steuerung menu options.

Objekt

The type of object to be created. The possible values are:

1	Linie
2	Rechteck
3	Ellipse
6	Textfeld
7	Schaltfläche
11	Kontrollkästchen
12	Optionsfeld
14	Bezeichnung
16	Drehfeld
17	Bildlaufleiste
18	Listenfeld
19	Gruppenfeld
20	Dropdown

Bezug1

The cell containing the top-left corner of the object.

x_Pos1

The 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.

y_Pos1

The 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.

Bezug2

The cell containing the bottom-right corner of the object.

x_Pos2

The 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.

y_Pos2

The 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.

Text

The text to be assigned to the object. If this parameter is omitted then no text is assigned.

Ausfüllen

Specifies whether the object is filled or transparent (not currently implemented).

Bearbeitung

Specifies whether a combo box is editable (not currently implemented).

OBJEKT.ZUORDNEN(Typ; [Objektbezeichnung]; [Erstes_Zeichen]; [Anzahl_Zeichen]; [Index])

Returns information about the specified object.

Typ

The type of information to return. The possible values are:

1	object type as number:
	1 Linie
	2 Rechteck
	3 Ellipse
	6 Textfeld
	7 Schaltfläche
	11 Kontrollkästchen
	12 Optionsfeld
	14 Bezeichnung
	16 Drehfeld
	17 Bildlaufleiste
	18 Listenfeld
	19 Gruppenfeld
	20 Dropdown
2	locked
3	z-order
4	top-left cell as R1C1 reference
5	x-offset of top-left corner in points
6	y-offset of top-left corner in points
7	bottom-right cell as R1C1 reference
8	x-offset of bottom-right corner in points
9	y-offset of bottom-right corner in points
10	reference of the macro as text
11	object positioning as number:
	1 Von Zellposition und -größe abhängig
	2 Nur von Zellposition abhängig
	3 Von Zellposition und -größe unabhängig
12	object text from start_num for count_num characters
13	font name
14	font size
15	bold
16	italic
17	underline
18	strikethrough
19	outline
20	shadow
21	text color
22	horizontal alignment as number:
	1 Links
	2 Mitte
	3 Rechts
	4 Bündig
23	vertical alignment as number:
	1 Oben
	2 Mitte
	3 Unten
	4 Bündig
26	visible
48	linked cell reference as text
49	object id number
56	enabled
62	current value
63	minimum value
64	maximum value
65	increment value
66	page value
71	list/combo entries
73	input range reference as text
74	dropdown lines
75	draw 3d

Objektbezeichnung

The object identifier. If this parameter is omitted it defaults to the currently selected object on the active worksheet.

Erstes_Zeichen

The text substring start position for type_num 12. If this parameter is omitted it defaults to 1.

Anzahl_Zeichen

The text substring length for type_num 12. If this parameter is omitted it defaults to 255.

Index

This parameter is not currently used.

OBJEKT.ZUWEISEN([Makrobezug])

Assigns a macro to an object.

Makrobezug

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

OPTIONEN.ANSICHT([Formel]; [Status]; [Kommentare]; [Info_anzeigen]; [Objekt]; [Seitenumbruch]; [Formeln]; [Gitternetzlinien]; [Farbe]; [Köpfe]; [Gliederung]; [Null]; [Hori_Bildlaufl]; [Vert_Bildlaufl]; [Register])

Changes the program, file or sheet view options.

Formel

Specifies whether the formula bar is displayed. The possible values are:

FALSCH	The formula bar is not displayed
WAHR	The formula bar is displayed

If this parameter is omitted the setting is not changed.

Status

Specifies whether the status bar is displayed. The possible values are:

FALSCH	The status bar is not displayed
WAHR	The status bar is displayed

If this parameter is omitted the setting is not changed.

Kommentare

Specifies whether comments and indicators are displayed (not currently implemented).

Info_anzeigen

Specifies whether the info window is displayed (not currently implemented).

Objekt

Specifies how objects are displayed (not currently implemented).

Seitenumbruch

Specifies whether page breaks are displayed (not currently implemented).

Formeln

Specifies whether to display formulas or values in cells. The possible values are:

FALSCH	Values are displayed
WAHR	Formulas are displayed

If this parameter is omitted the setting is not changed.

Gitternetzlinien

Specifies whether gridlines are displayed. The possible values are:

FALSCH	Gridlines are not displayed
WAHR	Gridlines are displayed

If this parameter is omitted the setting is not changed.

Farbe

Specifies the color to be used for drawing gridlines (not currently implemented).

Köpfe

Specifies whether row and column headings are displayed. The possible values are:

FALSCH	Row and column headings are not displayed
WAHR	Row and column headings are displayed

If this parameter is omitted the setting is not changed.

Gliederung

Specifies whether outline symbols are displayed (not currently implemented).

Null

Specifies whether zero values are displayed (not currently implemented).

Hori_Bildlaufl

Specifies whether the horizontal scroll bar is displayed. The possible values are:

FALSCH	The horizontal scroll bar is not displayed
WAHR	The horizontal scroll bar is displayed

If this parameter is omitted the setting is not changed.

Vert_Bildlaufl

Specifies whether the vertical scroll bar is displayed. The possible values are:

FALSCH	The vertical scroll bar is not displayed
WAHR	The vertical scroll bar is displayed

If this parameter is omitted the setting is not changed.

Specifies whether the sheet tabs are displayed. The possible values are:

FALSCH	The sheet tabs are not displayed
WAHR	The sheet tabs are displayed

If this parameter is omitted the setting is not changed.

ORDNEN([Ausrichtung]; [Schlüssel1]; [Reihenfolge1]; [Schlüssel2]; [Reihenfolge2]; [Schlüssel3]; [Reihenfolge3]; [Überschriften]; [Benutzerdefiniert]; [Groß_Kleinschreibung])

Simulates the Format Daten Sortieren menu option.

Ausrichtung

Specifies whether to sort the rows or columns. The possible values are:

1	Sort rows
2	Sort columns

If this parameter is omitted it defaults to 1.

Schlüssel1

Specifies 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.

Reihenfolge1

Specifies whether to sort the data in ascending or descending order. The possible values are:

1	Aufsteigend
2	Absteigend

If this parameter is omitted it defaults to 1.

Schlüssel2

Specifies a reference to the second column or row to sort on. If this parameter is omitted then the second key is not used.

Reihenfolge2

Specifies whether to sort the data in ascending or descending order. The possible values are:

1	Aufsteigend
2	Absteigend

If this parameter is omitted it defaults to 1.

Schlüssel3

Specifies a reference to the third column or row to sort on. If this parameter is omitted then the third key is not used.

Reihenfolge3

Specifies whether to sort the data in ascending or descending order. The possible values are:

1	Aufsteigend
2	Absteigend

If this parameter is omitted it defaults to 1.

Überschriften

Specifies whether the selected cells include a header row or column. The possible values are:

0	Determine the presence of a header automatically
1	There is a header
2	There is no header

If this parameter is omitted it defaults to 2.

Benutzerdefiniert

Specifies whether to use a custom list for the first sort key. The possible values are:

1	Use normal sort sequence
2	Day short names
3	Day long names
4	Month short names
5	Month long names

If this parameter is omitted it defaults to 1.

Groß_Kleinschreibung

Specifies whether the sort should be case-sensitive. The possible values are:

WAHR	The sort is case-sensitive
FALSCH	The sort is not case-sensitive

If this parameter is omitted it defaults to FALSCH.

POSTEXT(Bezug; [A1])

Returns a string containing the specified reference.

Bezug

The reference that is to be converted to text.

Specifies the style of the reference. The possible values are:

FALSCH	R1C1 style
WAHR	A1 style

If this parameter is omitted it defaults to FALSCH.

POSWERT(Bezug)

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.

Bezug

The reference to the cells whose values you want.

RAHMENART([Gesamt]; [Rand_links]; [Rand_rechts]; [Rand_oben]; [Rand_unten]; [Schraffieren]; [Farbe_Gesamt]; [Farbe_links]; [Farbe_rechts]; [Farbe_oben]; [Farbe_unten])

Simulates the Format Zellen dialog Rahmenart page.

Gesamt

The border type to be applied to the outline of the selected cells. The possible values are:

0	Keine
1	Dünn
2	Mittel
3	Gestrichelt
4	Gepunktet
5	Dick
6	Doppelt
7	Haarstrich

If this parameter is omitted the setting is not changed.

Rand_links

The border type to be used for the left border of the selected cells. The possible values are the same as for the Gesamt parameter.

If this parameter is omitted the setting is not changed.

Rand_rechts

The border type to be used for the right border of the selected cells. The possible values are the same as for the Gesamt parameter.

If this parameter is omitted the setting is not changed.

Rand_oben

The border type to be used for the top border of the selected cells. The possible values are the same as for the Gesamt parameter.

If this parameter is omitted the setting is not changed.

Rand_unten

The border type to be used for the bottom border of the selected cells. The possible values are the same as for the Gesamt parameter.

If this parameter is omitted the setting is not changed.

Schraffieren

Not implemented.

Farbe_Gesamt

The color to be used for the outline border. The possible values are:

0	Automatisch
1 to 56	One of the colors displayed in the Format Zellen dialog Rahmenart page

If this parameter is omitted the setting is not changed.

Farbe_links

The color to be used for the left border. The possible values are the same as for the Farbe_Gesamt parameter.

If this parameter is omitted the setting is not changed.

Farbe_rechts

The color to be used for the right border. The possible values are the same as for the Farbe_Gesamt parameter.

If this parameter is omitted the setting is not changed.

Farbe_oben

The color to be used for the top border. The possible values are the same as for the Farbe_Gesamt parameter.

If this parameter is omitted the setting is not changed.

Farbe_unten

The color to be used for the bottom border. The possible values are the same as for the Farbe_Gesamt parameter.

If this parameter is omitted the setting is not changed.

RECHTS.AUSFÜLLEN()

Simulates the Bearbeiten Ausfüllen Rechts menu option.

RELPOS(Bezug; Relativ_zu_Bezug)

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

Bezug	The target reference.
Relativ_zu_Bezug	The base reference.

SBILDLAUF(Position; [Zeile_Wahrheitswert])

Scrolls the worksheet vertically to the specified position.

Position

The proportional or absolute position to scroll to.

Zeile_Wahrheitswert

Whether the Position parameter represents a proportional or absolute row number. The possible values are:

FALSCH	The Position parameter is a number between 0 and 1 that represents how far down the worksheet to scroll to.
WAHR	The 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 FALSCH.

SBILDLAUF.SEITEN([Anzahl_Fenster])

Scrolls the worksheet vertically by the specified number of pages.

Anzahl_Fenster

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

SBILDLAUF.ZEILEN([Anzahl_Zeilen])

Scrolls the worksheet vertically by the specified number of rows.

Anzahl_Zeilen

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

SCHRIFTART.EIGENSCHAFTEN([Schriftart]; [Schnitt]; [Größe]; [Durchstreichen]; [Hochgestellt]; [Tiefgestellt]; [Kontur]; [Schatten]; [Unterstreichen]; [Farbe]; [Standard]; [Hintergrund]; [Erstes_Zeichen]; [Anzahl_Zeichen])

Simulates the Format Zellen dialog Schrift page or changes the font of the selected chart text.

Schriftart

The name of the font to be used.

Schnitt

The style to be used. The possible values are:

"Standard"	Removes the bold and italic attributes.
"Fett"	Sets the font to bold.
"Kursiv"	Sets the font to italic.
"Fett Kursiv"	Sets the font to bold and italic.

If this parameter is omitted the style is not changed.

Größe

The point size to be used. If this parameter is omitted the size is not changed.

Durchstreichen

Sets the strikethrough attribute. The possible values are:

FALSCH	The font does not have the strikethrough attribute
WAHR	The font has the strikethrough attribute

If this parameter is omitted the strikethrough attribute is not changed.

Hochgestellt

Not currently implemented.

Tiefgestellt

Not currently implemented.

Kontur

Not currently implemented.

Schatten

Not currently implemented.

Unterstreichen

The underline style to be used. The possible values are:

0	None
1	Single
2	Double (not currently implemented)
3	Single accounting (not currently implemented)
4	Double accounting (not currently implemented)

If this parameter is omitted the underline style is not changed.

Farbe

The color to be used. The possible values are:

0	Automatic
1 to 56	One of the colors displayed in the Format>Zellen>Schrift dialog box

If this parameter is omitted the color is not changed.

Standard

Not currently implemented.

Hintergrund

Not currently implemented.

Erstes_Zeichen

Not currently implemented.

Anzahl_Zeichen

Not currently implemented.

SIGNAL([Signalton])

Causes the computer to beep.

[Signalton]

A 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.

SKALIERUNG([Min_Num]; [Max_Num]; [Haupt]; [Hilfs]; [Schnittp]; [Logarith]; [Umgekehrt]; [Max])

Changes the attributes of the selected chart value axis scale.

Min_Num

The minimum value. If this parameter is omitted the setting is not changed.

Max_Num

The maximum value. If this parameter is omitted the setting is not changed.

Haupt

The major step value. If this parameter is omitted the setting is not changed.

Hilfs

The minor step value (not currently implemented).

Schnittp

The value at which the opposite axis crosses this axis (not currently implemented).

Logarith

Whether this scale is linear or logarithmic. The possible values are:

FALSCH	The scale is linear.
WAHR	The scale is logarithmic.

If this parameter is omitted the setting is not changed.

Umgekehrt

Whether the scale values are show in reverse order (not currently implemented).

Max

Whether the opposite axis crosses this axis at the maximum value (not currently implemented).

SPALTENBREITE([Breite]; [Bezug]; [Standard]; [Typ]; [Standardbreite])

Simulates the Format Spalte menu options.

Breite

The new width of the columns. The width is measured in characters. This parameter is ignored if Standard is WAHR or Typ is specified. If this parameter is omitted the width of the specified columns is not changed.

Bezug

The columns whose width is to be changed. If this parameter is omitted it defaults to the current selection on the active worksheet.

Standard

Specifies whether the columns are to be set to the standard column width. The possible values are:

WAHR	The columns are set to the standard width.
FALSCH	The columns are not set to the standard width.

If this parameter is omitted it defaults to FALSCH.

Typ

Specifies whether the columns are to be hidden, unhidden or automatically sized. This parameter is ignored if Standard is WAHR. The possible values are:

1	The columns are hidden.
2	The columns are unhidden.
3	The 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.

Standardbreite

Specifies 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.

SPEICHERN()

Simulates the Datei Speichern menu option.

SPEICHERN.UNTER([Datei]; [Typ]; [Kennwort_Schutz]; [Sicherung]; [Schreibschutz_Kennwort]; [Schreibsch_empfehlen])

Simulates the Datei Speichern Unter menu option.

Datei

The name for the saved file. If this parameter is omitted the current name will be used.

Typ

The type of file to save. The possible values are:

1	Excel workbook (xls)
3	Tab-delimited text (txt)
6	Comma-separated values (csv)
17	Excel template (xlt)

If this parameter is omitted it defaults to 1.

Kennwort_Schutz

The password required to unprotect a file (not currently implemented).

Sicherung

Whether to make a backup of the file (not currently implemented).

Schreibschutz_Kennwort

The password required to open a read-only file for writing (not currently implemented).

Schreibsch_empfehlen

Whether to save the file as read-only recommended (not currently implemented).

SPEZIALFILTER(Operation; Liste; [Kriterienbereich]; [Zielbereich]; [Keine_Duplikate])

Simulates the Format Daten Filter Spezialfilter menu option.

Operation

Whether to filter in place or copy to another location. The possible values are:

1	Filter the list in place
2	Copy the list to another location

Liste

The location of the list to be filtered.

Kriterienbereich

The location of any filter criteria to be used. If this parameter is omitted no criteria will be applied.

Zielbereich

The destination of the copied data. This is only used when operation is 2.

Keine_Duplikate

Whether to select unique records only. The possible values are:

FALSCH	Display all records that match the criteria.
WAHR	Display only unique records that match the criteria.

If this parameter is omitted it defaults to FALSCH.

STANDARDBREITE([Breite])

Simulates the Format Spalte Standardbreite menu option.

Breite

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

STEUERUNGSWERT.FESTLEGEN([Wert])

Changes the current value of a control.

Wert

The new value for the control. The possible values are:

Kontrollkästchen	0	Nicht aktiviert
	1	Aktiviert
	2	Gemischt
Optionsfeld	0	Nicht aktiviert
	1	Aktiviert
Drehfeld	The new value of the spin control
Bildlaufleiste	The new scroll position
Listenfeld	The selected item (0 = no selection)
Dropdown	The selected item (0 = no selection)

If this parameter is omitted the setting is not changed.

TEXT.ZUORDNEN(Zuordnen_zu_Zahl; [Datenreihennum]; [Datenpunktnum])

Attaches default text to the active chart. The AUSWÄHLEN and FORMEL functions can be used to change the text.

Zuordnen_zu_Zahl

The item where the default text is to be attached. The possible values are:

1	Chart title
2	Primary y-axis title
3	Primary x-axis title
4	Data label (not currently implemented)
5	Secondary y-axis title (not currently implemented)
6	Secondary x-axis title (not currently implemented)

Datenreihennum

The series number of the data label (not currently implemented)

Datenpunktnum

The point number of the data label (not currently implemented)

TEXTFELD(Text; [Objektbezeichnung]; [Erstes_Zeichen]; [Anzahl_Zeichen])

Changes the text of an object.

Text	The text that is to be added.
Objektbezeichnung	The object identifier. If this parameter is omitted it defaults to the currently selected object on the active worksheet.
Erstes_Zeichen	The start position in the existing text where the new text is to be inserted. If this parameter is omitted it defaults to 1.
Anzahl_Zeichen	The length of existing text that is to be replaced. If this parameter is omitted it defaults to the length of the existing text.

TEXTPOS(Text; [A1])

Returns a reference corresponding to the specified text.

Text

The string containing the reference.

Specifies the style of the reference. The possible values are:

FALSCH	R1C1 style
WAHR	A1 style

If this parameter is omitted it defaults to FALSCH.

TITEL.EINFÜGEN([Diagramm]; [Primär_y]; [Primär_x]; [Sekundär_y]; [Sekundär_x])

Attaches default text to the active chart. The AUSWÄHLEN and FORMEL functions can be used to change the text.

Diagramm

Whether to add a default chart title. The possible values are:

FALSCH	Delete any existing chart title.
WAHR	Add default chart title if one does not already exist.

If this parameter is omitted the chart title is not changed.

Primär_y

Whether to add a default primary y-axis title. The possible values are:

FALSCH	Delete any existing primary y-axis title.
WAHR	Add default primary y-axis title if one does not already exist.

If this parameter is omitted the primary y-axis title is not changed.

Primär_x

Whether to add a default primary x-axis title. The possible values are:

FALSCH	Delete any existing primary x-axis title.
WAHR	Add default primary x-axis title if one does not already exist.

If this parameter is omitted the primary x-axis title is not changed.

Sekundär_y

Whether to add a default secondary y-axis title (not currently implemented).

Sekundär_x

Whether to add a default secondary x-axis title (not currently implemented).

UNTEN.AUSFÜLLEN()

Simulates the Bearbeiten Ausfüllen Unten menu option.

URSPRUNG()

Returns information about the caller of the macro.

Macro called from:	Function returns:
User-defined function	reference of cell containing function call
User-defined function in array formula	reference of array formula range
Attached to control or drawing object	object identifier
Auto_öffnen macro	file name
Manually (control key combination)	error value #BEZUG!
BEI.DOPPELKLICK macro	reference of cell that was double-clicked
BEI.EINGABE macro	reference of cell where data was entered
BEI.BLATT macro	error value #BEZUG!

VERZEICHNIS([Pfad])

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

Pfad	The 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.

WARNUNG(Meldungstext; [Typ]; [Hilfebezug])

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

Meldungstext

The text to be displayed in the message box.

Typ

The type of message box to be displayed. The possible values are:

1	A box containing a question mark icon and OK and Abbrechen buttons.
2	A box containing an information icon and an OK button.
3	A box containing an exclamation icon and an OK button.

If this parameter is omitted it defaults to 2.

Hilfebezug

A reference to a Help topic (not currently implemented).

WBILDLAUF(Position; [Spalte_Wahrheitswert])

Scrolls the worksheet horizontally to the specified position.

Position

The proportional or absolute position to scroll to.

Spalte_Wahrheitswert

Whether the Position parameter represents a proportional or absolute column number. The possible values are:

FALSCH	The Position parameter is a number between 0 and 1 that represents how far across the worksheet to scroll to.
WAHR	The 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 FALSCH.

WBILDLAUF.SEITEN([Anzahl_Fenster])

Scrolls the worksheet horizontally by the specified number of pages.

Anzahl_Fenster

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

WBILDLAUF.SPALTEN([Anzahl_Spalten])

Scrolls the worksheet horizontally by the specified number of columns.

Anzahl_Spalten

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

WIDERRUFEN()

Simulates the Bearbeiten Rückgängig menu option.

ZEILENHÖHE([Höhe]; [Bezug]; [Standardhöhe]; [Typ])

Simulates the Format Zeile menu options.

Höhe

The new height of the rows. The height is measured in points. This parameter is ignored if Standardhöhe is WAHR or Typ is specified. If this parameter is omitted the height of the specified rows is not changed.

Bezug

The rows whose height is to be changed. If this parameter is omitted it defaults to the current selection on the active worksheet.

Standardhöhe

Specifies whether the rows are to be set to the standard row height. The possible values are:

WAHR	The rows are set to the standard height.
FALSCH	The rows are not set to the standard height.

If this parameter is omitted it defaults to FALSCH.

Typ

Specifies whether the rows are to be hidden, unhidden or automatically sized. This parameter is ignored if Standardhöhe is WAHR. The possible values are:

1	The rows are hidden.
2	The rows are unhidden.
3	The 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.

ZELLE.ZUORDNEN(Typ; [Bezug])

Returns information about the specified cell.

Typ

The type of information to return. The possible values are:

1	Absolute reference of the upper-left cell in reference, as text
2	Row number of the top cell in reference
3	Column number of the leftmost cell in reference
4	Same as TYP(Bezug)
5	Contents of reference
6	Formula in reference, as text
7	Number format of the cell, as text
8	Number indicating the cell's horizontal alignment
9	Number indicating the left-border style assigned to the cell
10	Number indicating the right-border style assigned to the cell
11	Number indicating the top-border style assigned to the cell
12	Number indicating the bottom-border style assigned to the cell
13	Number from 0 to 18, indicating the pattern of the selected cell
14	If the cell is locked, returns WAHR; otherwise, returns FALSCH
15	If the cell's formula is hidden, returns WAHR; otherwise, returns FALSCH
16	A 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 (WAHR) or is a custom width (FALSCH)
17	Row height of cell, in points
18	Name of font, as text
19	Size of font, in points
20	If the cell is bold returns WAHR; otherwise returns FALSCH
21	If the cell is italic returns WAHR; otherwise returns FALSCH
22	If the cell is underlined returns WAHR; otherwise returns FALSCH
23	If the cell is struck out returns WAHR; otherwise returns FALSCH
24	Font color of cell, as a number in the range 1 to 56. If font color is automatic, returns 0
25	If the cell is outlined returns WAHR; otherwise returns FALSCH
26	If the cell is shadowed returns WAHR; otherwise returns FALSCH
32	Name of the workbook and sheet containing the cell
33	If the cell is formatted to wrap, returns WAHR; otherwise, returns FALSCH
34	Left-border color as a number in the range 1 to 56. If color is automatic, returns 0
35	Right-border color as a number in the range 1 to 56. If color is automatic, returns 0
36	Top-border color as a number in the range 1 to 56. If color is automatic, returns 0
37	Bottom-border color as a number in the range 1 to 56. If color is automatic, returns 0
38	Shade foreground color as a number in the range 1 to 56. If color is automatic, returns 0
39	Shade background color as a number in the range 1 to 56. If color is automatic, returns 0
42	The horizontal distance, measured in points, from the left edge of the active window to the left edge of the cell
43	The vertical distance, measured in points, from the top edge of the active window to the top edge of the cell
44	The horizontal distance, measured in points, from the left edge of the active window to the right edge of the cell
45	The vertical distance, measured in points, from the top edge of the active window to the bottom edge of the cell
46	If the cell contains a comment, returns WAHR; otherwise, returns FALSCH
48	If the cell contains a formula, returns WAHR; if a constant, returns FALSCH
49	If the cell is part of an array, returns WAHR; otherwise, returns FALSCH
50	Number indicating the cell's vertical alignment
53	Contents of the cell as it is currently displayed, as text
57	If the cell is superscript returns WAHR; otherwise returns FALSCH
58	Returns the font style of the cell as text
59	Returns the number for the underline style
60	If the cell is subscript returns WAHR; otherwise returns FALSCH
66	Returns the book name of the workbook containing the cell in the form BOOK1.XLS

Bezug

The cell whose information is to be returned. If this parameter is omitted it defaults to the active cell.

ZELLEN.EINFÜGEN([Verschieben_Zahl])

Simulates the Einfügen Zellen menu option.

Verschieben_Zahl

The way in which the cell insertion is to be processed. The possible values are:

1	Nach rechts verschieben
2	Nach unten verschieben
3	Ganze Zeile
4	Ganze Spalte

If this parameter is omitted it defaults to 2.

ZELLSCHUTZ([Gesperrt]; [Formel_ausblenden])

Simulates the Format Zellen dialog Schutz page.

Gesperrt

Whether the cell should be locked when the sheet is protected. The possible values are:

FALSCH	The cell is not locked
WAHR	The cell is locked

If this parameter is omitted the setting is not changed.

Formel_ausblenden

Whether the cell formula should be hidden when the sheet is protected. The possible values are:

FALSCH	The cell formula is not hidden
WAHR	The cell formula is hidden

If this parameter is omitted the setting is not changed.

ZIELWERTSUCHE(Zielzelle; Zielwert; Variable_Zelle)

Simulates the Format Daten Zielwertsuche menu option.

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

ZOOM([Vergrößerung])

Simulates the Format Blatt Zoom menu option.

Vergrößerung

The magnification option. The possible values are:

number	Set the zoom level to the specified number. The number must be between 10 and 400.
WAHR	Set the zoom level so that the current selection fills the window.
FALSCH	Reset the zoom level to 100%

If this parameter is omitted it defaults to WAHR.

ÖFFNEN(Datei; [Verknüpfungen_aktual]; [Schreibschutz]; [Trenner]; [Kennwort]; [Schreibschutz_Kennwort]; [Schreibsch_ignorieren]; [Dateiursprung]; [Benutzerdef_Text]; [Wahrheitswert]; [Bearbeitung]; [Zugriff]; [Benachrichtigen]; [Umwandlung])

Simulates the Datei Öffnen menu option.

Datei

The name of the file to be opened.

Verknüpfungen_aktual

Whether to update external references. The possible values are:

0	Do not update any references
1	Update external references
2	Update remote references (not currently implemented)
3	Update external and remote references (not currently implemented)

If this parameter is omitted and external references exist then a prompt will be displayed.

Schreibschutz

Whether to open the file as read-only (not currently implemented).

Trenner

The character used as a delimiter for text files. The possible values are:

1	Tab
2	Dezimal
3	Leerzeichen
4	Semikolon
5	Nothing
6	Benutzerdefiniert (specified in the Benutzerdef_Text parameter)

If this parameter is omitted the text file delimiter will be determined from the file extension.

Kennwort

The password required to unprotect a file (not currently implemented).

Schreibschutz_Kennwort

The password required to open a read-only file for writing (not currently implemented).

Schreibsch_ignorieren

Whether to suppress the display of the read-only recommended message (not currently implemented).

Dateiursprung

The operating system where the file originated (not currently implemented).

Benutzerdef_Text

The character used as a custom delimiter for text files.

Wahrheitswert

Whether to add the specified file to the current workbook (not currently implemented).

Bearbeitung

Whether a template file should be opened in read-write mode (not currently implemented).

Zugriff

Whether to change the access of a currently open file (not currently implemented).

Benachrichtigen

Whether to send a message when a shared workbook becomes available (not currently implemented).

Umwandlung

Overrides the default file type (not currently implemented).