numbers in a column excel code example

Example 1: excel vba get column number from column name

'For column IV...

ColNum = Columns("IV").Column

Example 2: excel count columns with text

=COUNTIF(B4:B8,"*")