I am confused as to why vba excel, after accepting to dive into the three letter range in both functions, decides not to work when approaching ZZZ.
Functions are suppose to convert Column letter to number equivalent.
Any ideas?
Code:
Function ColumnLetterToNumber(Letters As String) As Long
ColumnLetterToNumber = Range(Letters & "1").Column
End Function
Function ColumnLetterToNumber1(Letters As String) As Long
ColumnLetterToNumber1 = ThisWorkbook.Worksheets(1).Columns(Letters).Column
End Function
Any ideas?