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:
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.