Help Center

MergeColproperty

Returns or sets a value that determines which columns can have their contents merged. This property must be True to use the MergeCells property.

Windowspropertydoc-orphan
No implementation located. This member is documented, but the source scan found no matching declaration. It is likely declared in a header this scan does not resolve, or provided by a macro.

Syntax

PROPERTY MergeCol (BYVAL Index AS LONG) AS BOOLEAN
FUNCTION MergeCol (BYVAL Index AS LONG, BYVAL merge AS BOOLEAN)

Parameters

NameDescription
IndexThe zero-based index of the column you want to configure.
mergeTrue enables merging for that column; False (default) disables it.

Description

Returns or sets a value that determines which columns can have their contents merged. This property must be True to use the MergeCells property.

Remarks

Setting MergeCol to True will only result in a visible merge if the following global conditions are met:

  • The MergeCells property must be set to a value other than flexMergeNever (0).
  • Vertical cells must contain the exact same string.
  • Merged cells typically inherit the alignment of the top-most cell in the merged group.

Example

' 1. Enable merging globally grid.MergeCells = flexMergeRestrictColumns

' 2. Enable merging for the first column (Column 0) grid.MergeCol(0) = True

' 3. Populate data (Cells with "North" will merge vertically) grid.TextMatrix(1, 0) = "North" grid.TextMatrix(2, 0) = "North"

Reference