View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
bhofsetz[_127_] bhofsetz[_127_] is offline
external usenet poster
 
Posts: 1
Default column command to return letter


Gary,
Did you ever remember how to do find the column letter? I'm
trying to do the same thing and can't figure it out either.

I'd like to return the column letter from a cell reference

i.e. for cell(5,y)

It would return L if y = 13
or D if y = 4

etc.

Does anyone know how to do this?

Thanks


--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=530389