vba naming column code example

Example: excel vba get column name from number

'For column number 256...

ColName = Split(Cells(, 256).Address, "$")(1)