excel vba get column number from column name code example Example: excel vba get column number from column name 'For column IV... ColNum = Columns("IV").Column