Управление макросами 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 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 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. |