hiding columns automatically
 

I have a number of columns on a spreadsheet that need not be viewed or
printed if a given field within that range is zero. I am lloking for syntax
that will automatically hide (say) columns a to f where the value in (say)
c20 is less than 1?

I have macro that closes the columns if I select them manually but given
volumes need to do this automatically.

Any ideas


Thanks