AX2353

GetColumnLetter function

Returns the column letter of the current cell, of the active cell when the file was refreshed, or for a specific cell reference.

The intent of GetColumnLetter is to help support custom drilling in Axiom files using double-click.

Syntax

GetColumnLetter("Cell")

The parameter Cell takes the following values:

  • <Blank>: Leave the Cell parameter blank (open parentheses) to return the column letter for the current cell (the cell that contains the GetColumnLetter function).

  • Active: Use this keyword to return the column letter for the cell that was active when the last recalculation occurred.

  • CellReference: Enter a cell address to return the column letter for that cell.

All non-numeric entries must be placed in double quotation marks, unless you are using cell references to reference the text held in another cell.

Remarks

  • Drilling initiates a recalculation, so Active can be used to identify the column where the user double-clicked to perform the drill.
  • GetColumnLetter is a volatile function.

Examples

=GetColumnLetter()

This example returns the column letter for the cell that contains the GetColumnLetter function (for example: "A").

=GetColumnLetter("Active")

This example returns the column letter for the active cell when the file was refreshed (for example: "F").

=GetColumnLetter("AD25")

This example returns the column letter for the specified cell address ("AD" in this case).

See also