I want to set a formula that finds the maximum value from every second column
across the whole worksheet. I know column no mod 2 can be used with vba but
how do i incorporate this into a formula.

Thanks