View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ellebelle ellebelle is offline
external usenet poster
 
Posts: 34
Default CHAR funtcion with double letter columns

Thanks, but what is a UDF? where do I put this?



"Mike H" wrote:

Try this UDF

Function CLetter(CNumber As Integer) As String
CLetter = Left(Cells(1, CNumber).Address _
(False, False), 1 - (CNumber 26))
End Function

call it with =cletter(n)


Mike
"ellebelle" wrote:

I am using this function:

CHAR(MATCH(P$1,$1:$1,)+64)

to get teh column letter, however it does not count double letters past
column z. As in AA AB etc.

Is there a way to get this?

Ellen