Управление макросами 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. |
ДЛЯ(имя_счетчика, нач_ном, кон_число, [шаг_ном])
Performs a group of instructions a specified number of times. The end of the group is indicated by a СЛЕД function.
имя_счетчика | A defined name that will be used to store the current index. |
нач_ном | The initial value to be assigned to the counter. |
кон_число | The last value to be assigned to the counter. |
шаг_ном | The value to be added to the counter each time around the loop. If this parameter is omitted it defaults to 1. |
ДЛЯ.ЯЧЕЙКИ(ссылка_на_имя, [ссылка_на_область], [проп_пустые])
Performs a group of instructions for each cell in a specified area. The end of the group is indicated by a СЛЕД function.
ссылка_на_имя | A defined name that will be used to store the current reference. | ||||
ссылка_на_область | The range of cells to be processed. | ||||
If this parameter is omitted it defaults to the current selection. | |||||
проп_пустые | Whether blank cells are to be skipped. The possible values are: | ||||
| |||||
If this parameter is omitted it defaults to ЛОЖЬ. |
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 ИНАЧЕ.ЕСЛИ.
Specifies the number of levels that will be skipped when this macro returns.
номер_уровня | The number of levels to skip. If this parameter is omitted then all levels are skipped. |
Forces the macro to continue with the statement at the reference.
ссылка | The reference of the cell where macro execution is to continue. |
Specifies whether a user-defined function is to be recalculated each time the worksheet changes.
флаг | Whether the function is volatile. The possible values are: | ||||
| |||||
If this parameter is omitted it defaults to ИСТИНА. |
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 ДЛЯ, ДЛЯ.ЯЧЕЙКИ or ПОКА loop. The macro will continue with the statement after the СЛЕД function.
Specifies the return type of a user-defined function.
ном_типа | The preferred data type(s) for the return 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. |
Specifies the end of the block of statements contained in a ДЛЯ, ДЛЯ.ЯЧЕЙКИ or ПОКА loop.
Terminates all running macros.
флаг_закрытия | Whether, in an Авто_закрыть macro, to prevent the workbook from being closed (not currently implemented). |
УСТАНОВИТЬ.ЗНАЧЕНИЕ(ссылка, значения)
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. |