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