excel copy to new column uniquew code example

Example 1: excel vba get column number from column name

'For column IV...

ColNum = Columns("IV").Column

Example 2: excel vba get column name from number

'For column number 256...

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