2.2.2.6 mlabelbywcol


Contents

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 ms

Input/Output

MatrixLayer

<active>

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

0

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.

Mlabelbywcol.png


Related X-Functions

mdim, mexpand, mproperty, mreplace, mrotate90, msetvalue, mflip, mtranspose , msmooth

Keywords:label