Home > VBAUsefulCodes
I had a very difficult time identifying column letters with column numbers. This following snippet made my life easy. check it out.
Convert Number To Column Letter Vba Excel
I had a very difficult time identifying column letters with column numbers. This following snippet made my life easy. check it out.
Sub Convert_Number_To_Column_Letter()
MsgBox Col_Letter(4)
End Sub
Function Col_Letter(lngCol As Long) As String
Dim vArr
vArr = Split(Cells(1, lngCol).Address(True, False), "$")
Col_Letter = vArr(0)
End Function
Subscribe
More to Explore
Tags
VBA Outlook KPI Excel Alt+F11 Dashboards Macros Recording Graphs Automation Developer WaterFall Powerpoint Charts Pivot Tables Forecast Charts