Управление макросами functions
[ ] indicates optional parameters
АРГУМЕНТ([строка_имени], [номер_типа_данных], [ссылка])АРГУМЕНТ([строка_имени], [номер_типа_данных], [ссылка])
Defines an argument for a custom function.
| строка_имени | The defined name that will be assigned to the argument. If this parameter is omitted then no name will be assigned. | ||||||||||||
| номер_типа_данных | 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. | |||||||||||||
| ссылка | The cell reference where the argument value will be stored. If this parameter is omitted then the argument value will not be stored. |
Forces the macro to end, and if it is a custom function then to return the specified value.
| значение | For custom functions, the value to be returned. |
Specifies a logical test that conditions the execution of a block of statements.
| логическое_выражение | An expression that results in ИСТИНА or ЛОЖЬ. |
Forces the macro to wait until the date/time specified by the serial number.
| дата_как_число | The date/time when the macro is to resume. If this parameter is omitted the macro does not wait. |
Introduces the block of statements to be processed when the corresponding ЕСЛИ or ИНАЧЕ.ЕСЛИ condition is false.
ИНАЧЕ.ЕСЛИ(логическое_выражение)
Specifies another logical test that conditions a block of statements when the corresponding ЕСЛИ or ELSE.IF condition is false.
| логическое_выражение | An expression that results in ИСТИНА or ЛОЖЬ. |
Specifies the end of the block of statements conditioned by the corresponding ЕСЛИ or ИНАЧЕ.ЕСЛИ.
Forces the macro to continue with the statement at the reference.
| ссылка | The reference of the cell where macro execution is to continue. |
Specifies a logical test that conditions the execution of a block of statements multiple times. The statements between the ПОКА and СЛЕД functions will be repeated as long as the logical test returns the value ИСТИНА.
| лог_выражение | An expression that results in ИСТИНА or ЛОЖЬ. |
Ends the processing of a ПОКА-СЛЕД loop. The macro will continue with the statement after the СЛЕД function.
Specifies the end of the block of statements contained in a ПОКА-СЛЕД loop. The logical test in the corresponding ПОКА statement will be done again, and if it is true then the block of statements in the loop will be executed again, otherwise execution will continue with the statement after this СЛЕД.
УСТАНОВИТЬ.ЗНАЧЕНИЕ(ссылка, значения)
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.
| ссылка | The cells where the values are to be stored. |
| значения | The values to be stored. |
УСТАНОВИТЬ.ИМЯ(текст_имени, [значение])
Assigns a defined name to the specified value.
| текст_имени | The defined name to use. |
| значение | The value to be associated with the name. If this parameter is omitted then the name is deleted. |