XLS Object

MergeCells

 
Syntax
 
XLS.MergeCells Row1, Col1, Row2, Col2
 
Description
Merges two or more cells in the selected range into one single cell.
 
Cell merge is a common feature in tables as in Excel as well. The span can hold multiple rows and columns. Please take notice that the rows and colums are one-based arrays. Therefore, when referring to Excel cell "A1", row and column numbers are 1 and 1.
 
Parameter
Description
Row1
Long integer, required. The first row in the range.
Col1
Integer, required. The first column in the range.
Row2
Long integer, required. The last row in the range.
Col2
Integer, required. The last column in the range.
 
See Also
SelectRange
Example
 
Sub Main
 
Dim x As Integer
 
   If Not XLS.AppInit() Then Exit Sub
 
   XLS.AppVisible = True
 
   XLS.AddWorkBook
   XLS.AddWorkSheet "Test1"
 
   XLS.MergeCells 3, 1, 6, 1
 
   For x = 1 To 10
      XLS.Value(x, 1) =  "Waarde " & CStr(x)
   Next x
 
   For x = 1 To 10
      Debug.Print XLS.Value(x, 1)
   Next x
 
   XLS.AppClose
 
End Sub