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