Syntax
| XLS.SelectRange Row1, Col1[, Row2][, Col2][, ApplyFont][, Alignment][, Highlight]
| ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Description
| Selects a range of cells and optionally applies some formatting on the selection.
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.
| ||||||||||||||||
See Also
| |||||||||||||||||
Example
| Sub Main
Dim x As Integer
If Not XLS.AppInit() Then Exit Sub
XLS.AppVisible = True
XLS.AddWorkBook
XLS.AddWorkSheet "Test1"
For x = 1 To 10
XLS.Value(x, 1) = "Waarde " & CStr(x)
Next x
XLS.Font.Bold = True
XLS.SelectRange 3, 1, 5, 1, True, xlAlignRight , True
XLS.AppClose
End Sub
|