Conditionally Hide Columns based on cell result

Originally Posted by montego

I'm still curious why the Range its referencing are rows 1:100, but, it seems to be working
Any one care to elaborate on why the B1:B100 Range Works?

You will discover that it hides the column when you change ANY cell in rows 1:100 to 0.
If you want it to hide the column only when row 3 is changed to 0 then use B3:BA3