specifying a cell reference in a formula

Can I specify a cell in a formula in a format other than "A10" or "B112"? I would like to refer to the cells by column number instead of column letter, since I will not know when coding this exactly what column the formula will end up in. If this is not possible, is there a utility to pass in a column number and have returned the corresponding column letter?

1 Reply

AD Administrator Syncfusion Team April 15, 2003 08:23 PM UTC

You can only use the alpha-numeric notation like A10 or B112. You can use the static (Shared in VB) method GridRangeInfo.GetAlphaLabel to convert a column number to a alpha label.

Loader.
Up arrow icon