|
STRCOLID function
The STRCOLID function returns an alphabetic column name (A to XFD) given a column number.
STRCOLID Syntax
STRCOLID(jColNo)
JColNo
jColNo is the number of the column you want to convert to a column name.
STRCOLID Remarks
If the column number is greater than 16384 STRCOLID returns #N/A
STRCOLID can be used either as a worksheet function or from VBA.
The main use of STRCOLID as a worksheet function is to calculate a cell address as a string for use with INDIRECT.
|
