cellname()

Read(2161) Label: excel cell name, row, column,

Description:

Return an Excel cell name according to specific row and column numbers.

Syntax:

cellname(r,c)

Note:

The function finds the name of an Excel cell through row parameter r and column parameter c.

Parameter:

r

The rth row in an Excel sheet, which is an integer greater than 0

c

The cth column in an Excel sheet, which is an integer greater than 0

Return value:

String

Example:

cellname(1,1)

Result: A1.

cellname(4,3)

Result: C4.

cellname(124,198)

Result: GP124.