data

The data parameter represents a data range for a macro function to act upon. It can typically be a constant, a column, or a cell range (see the specific macro function for details). The format for the data parameter is as follows:

begin_data [: end_data]

Where begin_data can be a constant (for example, 10.2), the name of a column (for example, V1), or a cell range (for example, V1[1:100]). The end_data parameter is optional. If it is provided, begin_data is used as a starting point and must be a column or a cell range. The ending point is specified by end_data.

Some other parameter names also use the same format as data. The description of these parameters refer to this section and format.