XLS Object

CellName

 
Syntax
 
strName =XLS.CellName(Row, Col)
 
Description
This function returns the cellname for the given numeric coordinates. It can be used as a conversion tool to create cell referencing in Excel formula's.
 
Note: this method requires an numeric values for row and column definition. De leftmost upper cell in a worksheet, referred in Excel by with cellname "A1" equals row 1 and col 1.
 
Parameter
Description
Row
Long integer, required. One-based numeric value representing the row of the active worksheet.
Col
Integer, required. One-base numeric value representing the column of the active worksheet.
 
See Also

Example
 
Sub Main
 
Dim strName As String
 
   If Not XLS.AppInit() Then Exit Sub
 
   XLS.AppVisible = True
 
   strName = XLS.AddWorkBook()
 
   Debug.Print XLS.CellName(2,2)   'B2
 
   XLS.CloseWorkBook
 
   XLS.AppClose
 
End Sub