Makrosteuerung Funktionen
[ ] indicates optional parameters
ABBRECHEN()Ends the processing of a FÜR, FÜR.ZELLE or SOLANGE loop. The macro will continue with the statement after the WEITER function.
ARGUMENT([Namen]; [Typ]; [Bezug])
Defines an argument for a custom function.
| Namen | The defined name that will be assigned to the argument. If this parameter is omitted then no name will be assigned. | ||||||||||||
| Typ | The acceptable data type(s) for the argument value. It can be any combination of the following (to specify more than one value, add the numbers together): | ||||||||||||
| |||||||||||||
| If this parameter is omitted it defaults to 7. | |||||||||||||
| Bezug | The cell reference where the argument value will be stored. If this parameter is omitted then the argument value will not be stored. |
Specifies the end of the block of statements conditioned by the corresponding WENN or SONST.WENN.
FÜR(Zähler; Anfang; Ende; [Schrittweite])
Performs a group of instructions a specified number of times. The end of the group is indicated by a WEITER function.
| Zähler | A defined name that will be used to store the current index. |
| Anfang | The initial value to be assigned to the counter. |
| Ende | The last value to be assigned to the counter. |
| Schrittweite | The value to be added to the counter each time around the loop. |
| If this parameter is omitted it defaults to 1. |
FÜR.ZELLE(Bezug; [Bezugsbereich]; [Überspringen])
Performs a group of instructions for each cell in a specified area. The end of the group is indicated by a WEITER function.
| Bezug | A defined name that will be used to store the current reference. | ||||
| Bezugsbereich | The range of cells to be processed. | ||||
| If this parameter is omitted it defaults to the current selection. | |||||
| Überspringen | Whether blank cells are to be skipped. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to FALSCH. |
Forces the macro to continue with the statement at the reference.
| Bezug | The reference of the cell where macro execution is to continue. |
Assigns a defined name to the specified value.
| Name | The defined name to use. |
| Wert | The value to be associated with the name. If this parameter is omitted then the name is deleted. |
Specifies the number of levels that will be skipped when this macro returns.
| Ebene | The number of levels to skip. If this parameter is omitted then all levels are skipped. |
Forces the macro to end, and if it is a custom function then to return the specified value.
| Wert | For custom functions, the value to be returned. |
Specifies a logical test that conditions the execution of a block of statements multiple times. The statements between the SOLANGE and WEITER functions will be repeated as long as the logical test returns the value WAHR.
| Prüfung | An expression that results in WAHR or FALSCH. |
Introduces the block of statements to be processed when the corresponding WENN or SONST.WENN condition is false.
Specifies another logical test that conditions a block of statements when the corresponding WENN or SONST.WENN condition is false.
| Prüfung | An expression that results in WAHR or FALSCH. |
Terminates all running macros.
| Abbrechen | Whether, in an Auto_schließen macro, to prevent the workbook from being closed (not currently implemented). |
Forces the macro to wait until the date/time specified by the serial number.
| serial_number | The date/time when the macro is to resume. If this parameter is omitted the macro does not wait. |
Specifies the end of the block of statements contained in a FÜR, FÜR.ZELLE or SOLANGE loop.
Specifies a logical test that conditions the execution of a block of statements.
| Prüfung | An expression that results in WAHR or FALSCH. |
Stores the specified values in the specified cells on the macro sheet. Do not use this function to try to update cells on a worksheet.
| Bezug | The cells where the values are to be stored. |
| Werte | The values to be stored. |