Funkcji sterowanie makrami
[ ] indicates optional parameters
ARGUMENT([nazwa_tekst], [nr_typu_danych], [adres])ARGUMENT([nazwa_tekst], [nr_typu_danych], [adres])
Defines an argument for a custom function.
nazwa_tekst | The defined name that will be assigned to the argument. If this parameter is omitted then no name will be assigned. | ||||||||||||
nr_typu_danych | 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. | |||||||||||||
adres | The cell reference where the argument value will be stored. If this parameter is omitted then the argument value will not be stored. |
DLA(licznik_tekst, liczba_początkowa, liczba_końcowa, [krok_liczba])
Performs a group of instructions a specified number of times. The end of the group is indicated by a NAST function.
licznik_tekst | A defined name that will be used to store the current index. |
liczba_początkowa | The initial value to be assigned to the counter. |
liczba_końcowa | The last value to be assigned to the counter. |
krok_liczba | The value to be added to the counter each time around the loop. |
If this parameter is omitted it defaults to 1. |
DLA.KOMÓRKI(adres_nazwa, [obszar_adres], [pomiń_puste])
Performs a group of instructions for each cell in a specified area. The end of the group is indicated by a NAST function.
adres_nazwa | A defined name that will be used to store the current reference. | ||||
obszar_adres | The range of cells to be processed. | ||||
If this parameter is omitted it defaults to the current selection. | |||||
pomiń_puste | Whether blank cells are to be skipped. The possible values are: | ||||
| |||||
If this parameter is omitted it defaults to FAŁSZ. |
Specifies a logical test that conditions the execution of a block of statements multiple times. The statements between the DOPÓKI and NAST functions will be repeated as long as the logical test returns the value PRAWDA.
test_logiczny | An expression that results in PRAWDA or FAŁSZ. |
Forces the macro to continue with the statement at the reference.
odwołanie | The reference of the cell where macro execution is to continue. |
Introduces the block of statements to be processed when the corresponding JEŻELI or INACZEJ.JEŻELI condition is false.
Specifies another logical test that conditions a block of statements when the corresponding JEŻELI or INACZEJ.JEŻELI condition is false.
test_logiczny | An expression that results in PRAWDA or FAŁSZ. |
Specifies a logical test that conditions the execution of a block of statements.
test_logiczny | An expression that results in PRAWDA or FAŁSZ. |
Specifies the end of the block of statements conditioned by the corresponding JEŻELI or INACZEJ.JEŻELI.
Specifies the end of the block of statements contained in a DLA, DLA.KOMÓRKI or DOPÓKI loop.
OKREŚL.NAZWĘ(nazwa_tekst, [wartość])
Assigns a defined name to the specified value.
nazwa_tekst | The defined name to use. |
wartość | The value to be associated with the name. If this parameter is omitted then the name is deleted. |
OKREŚL.WARTOŚĆ(adres, wartości)
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.
adres | The cells where the values are to be stored. |
wartości | The values to be stored. |
Forces the macro to wait until the date/time specified by the serial number.
liczba_kolejna | The date/time when the macro is to resume. If this parameter is omitted the macro does not wait. |
Forces the macro to end, and if it is a custom function then to return the specified value.
wartość | For custom functions, the value to be returned. |
Ends the processing of a DLA, DLA.KOMÓRKI or DOPÓKI loop. The macro will continue with the statement after the NAST function.