2.2.2.6 mlabelbywcol

1 Brief Information
2 Command Line Usage
3 X-Function Execution Options
4 Variables
5 Description
6 Related X-Functions

Brief Information

Set matrix object label by Worksheet column index

Command Line Usage

mlabelbywcol ref:=[Book1]Sheet1!2 pos:=comment;

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Display
Name

Variable
Name

I/O
and
Type

Default
Value

Description

Matrix Layer

Input/Output

MatrixLayer

Change the Long Name/Comment of matrix object in the matrix sheet.

Reference Column for Matrix Label

ref

Input/Output

Range

Specify the column as reference for Matrix Label

Label Position

pos

Input/Output

int

Specifies which lable

Option list:

0=ln:Long Name
1=comment:Comments

Description

Before run the mlabelbywcol X-Function, the matrix object (Z labels) Long Name/ Comment need to be typed the index number of the cells in the column. Running this X-Function, the matrix object Long Name/ Comment will be set reference cell index in specified column.