By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step - Convert a Column Number to its Letter Equivalent

Function ColumnLetter(c)

' c is the numerical col

a = Split(Cells(1, c).Address, "$")

ColumnLetter = a(1)



End Function