how to get column name from column index in vba excel code example
Example: excel vba get column name from number
'For column number 256...
ColName = Split(Cells(, 256).Address, "$")(1)
'For column number 256...
ColName = Split(Cells(, 256).Address, "$")(1)