Conditionally Hide Columns

Hi Gos

Check this file out. I have an issue with some bits of your code. Mainly with what columns to hide.

There seems to me that there are some conflicting overlaps

What should this end up as True or False?

Columns("U:CQ").Hidden = True

Some coditions set this as False Then the final line sets them back to True
Overlaps on "CQ"?

I have also tied all the conditions to the active row, I think that is correct.

Don't worry about protection just now let's get the code correct first.

Got to go now but I'll look in when I get back in a few hours time