get all column names which contain string in vba 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)