Navigation: FXLV4_Manager > Using FastExcel calculation methods from VBA >

STRCOLID function

 

 

 

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.

 

 

 

Copyright © 2020 Decision Models Ltd