Answers for "how to get column id in excel vba"

excel vba get column name from number

'For column number 256...

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

Posted by: Guest on March-26-2020

excel vba get column number from column name

'For column IV...

ColNum = Columns("IV").Column

Posted by: Guest on March-26-2020

Code answers related to "how to get column id in excel vba"