Fordraiders
asked on
Column Letter to a Column Number
vba...
Is this code correct?
If i pass "A" = strLet
It comes back as "1" should it not be "0"
Public Function ColumnLetterToNumber(strLe t As String)
Dim InputLetter As String
Dim OutputNumber As Integer
Dim Leng As Integer
Dim i As Integer
'InputLetter = InputBox("The Converting letter?") ' Input the Column Letter
Leng = Len(strLet)
OutputNumber = 0
For i = 1 To Leng
OutputNumber = (Asc(UCase(Mid(strLet, i, 1))) - 64) + OutputNumber * 26
Next i
'MsgBox OutputNumber 'Output the corresponding number
LtoN = OutputNumber
End Function
Freakin out on columns...
Columns start with zero ?
Thanks
fordraiders
Is this code correct?
If i pass "A" = strLet
It comes back as "1" should it not be "0"
Public Function ColumnLetterToNumber(strLe
Dim InputLetter As String
Dim OutputNumber As Integer
Dim Leng As Integer
Dim i As Integer
'InputLetter = InputBox("The Converting letter?") ' Input the Column Letter
Leng = Len(strLet)
OutputNumber = 0
For i = 1 To Leng
OutputNumber = (Asc(UCase(Mid(strLet, i, 1))) - 64) + OutputNumber * 26
Next i
'MsgBox OutputNumber 'Output the corresponding number
LtoN = OutputNumber
End Function
Freakin out on columns...
Columns start with zero ?
Thanks
fordraiders
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER