BTW Column S is 19, not 20

Function GetColNum(myColumn As String) As Integer
GetColNum = Columns(myColumn & ":" & myColumn).Column
End Function

=getcolnum("s") returns 19


Gord Dibben MS Excel MVP

On Fri, 11 Jan 2008 08:34:07 -0800, rk0909
wrote:

Hello,

I want to create a formula where the input is an alphbet representing a
column (e.g. S) but i want that to be interpretted as a number corresponding
to the alphabets rank (20 in this case). Is there a conversion formula that
exists?

thanks,

RK