View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default need a function for numbers to characters

Eric,

Give this a try...
'-------------------------------------------------
'Jim Cone - August 05, 2004
'Returns alphabetic equivalent of provided number.
'Returns nothing for numbers 256.

Function GetLetters(ByVal ColumnNum As Long) As String
On Error GoTo NoNumber
Dim ColChars As String
ColChars = Columns(ColumnNum).Address(False, False)
GetLetters = Left$(ColChars, 1)
Exit Function
NoNumber:
Beep
GetLetters = vbNullString
End Function

'Call it this way...

Sub GetLetter()
Dim strAlpha As String
strAlpha = GetLetters(25)
MsgBox strAlpha
End Sub
'-------------------------------------------------

Regards,
Jim Cone
San Francisco, CA

"Eric Marple" wrote in message ...
Is there a method or function that will take a number and
give me the corresponding character?