How to get the alphabetical reference of a cell

I

ice

Hi,

I am a newbie to excel/macro development.

I wanted to know how to get the alphabetical reference of a column based on
a cell. For example, the formula =Column(C2) gives me the value of 3. But i
need to get 'C' instead of 3. May I know how to go about getting 'C' using an
excel formula?

Thanks
 
B

Bob Buckland ?:-\)

Hi Ice,

You may want to use the link below to also post this to the MS Excel newsgroup and include the version of Excel you're using.

==========
Hi,

I am a newbie to excel/macro development.

I wanted to know how to get the alphabetical reference of a column based on
a cell. For example, the formula =Column(C2) gives me the value of 3. But i
need to get 'C' instead of 3. May I know how to go about getting 'C' using an
excel formula?

Thanks>>
--
Please let us know if this has helped,

Bob Buckland ?:)
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com
 
I

ice

Sure. Thanks Bob. :)


Bob Buckland ?:-) said:
Hi Ice,

You may want to use the link below to also post this to the MS Excel newsgroup and include the version of Excel you're using.

==========
Hi,

I am a newbie to excel/macro development.

I wanted to know how to get the alphabetical reference of a column based on
a cell. For example, the formula =Column(C2) gives me the value of 3. But i
need to get 'C' instead of 3. May I know how to go about getting 'C' using an
excel formula?

Thanks>>
--
Please let us know if this has helped,

Bob Buckland ?:)
MS Office System Products MVP


LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com
Click to expand...
 
Top