View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
vbapro[_2_] vbapro[_2_] is offline
external usenet poster
 
Posts: 9
Default Column Number from Column Letter

Function ColLetterToNumber(Letter As String) As Long
ColLetterToNumber = Columns(Letter).Column
End Function


"Robert" wrote:

I have the column letter of a cell and I need the column number. I know this
must be simple but I cannot figure out how to do it.
--
Robert Hill