Column Letter

Converting a Column Number to its equivalent Column Letter

Function ColLetter2(ColNumber As Integer) As String 
    ColLetter2 = Left(Cells(1, ColNumber).Address(False, False), _
                  Len(Cells(1, ColNumber).Address(False, False)) - 1)
End Function


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext