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. |