We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

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.

Live Chat Icon For mobile
Up arrow icon