View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers,microsoft.public.excel.misc,microsoft.public.excel.programming
Sathyaish Sathyaish is offline
external usenet poster
 
Posts: 3
Default Excel - Return column alphabet from column number

Is there some function in Excel (VBA) that will get me the column
alphabet if I provide the column number, or do I have to write one. I
ask because I know that there is, yet I recall I wrote this
functionality for the previous application, and I don't want to:

(1) Reuse it, if there's something in-built
(2) Re-invent the wheel

Help!

PS: I'm looking for something like:



code:--------------------------------------------------------------------------------
Function GetAlphabet(ByVal ColumnNumber as Long) as String
--------------------------------------------------------------------------------


which if I call must say:


code:--------------------------------------------------------------------------------
GetAlphabet(1)
--------------------------------------------------------------------------------


Output: "A"