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:
which if I call must say:Code:Function GetAlphabet(ByVal ColumnNumber as Long) as String
Output: "A"Code:GetAlphabet(1)




Reply With Quote