Hide columns based on cell value

[jwillis07]

Hi all,

Does anyone know if it is possible to hide columns based on the value of a specific cell?

For instance, if cell C5 = "" then hide column C.

Many thanks,

Jason

[Pete_UK]

You can't do it using a formula - you would need a macro to do that.

Pete

[jwillis07]

You can't do it using a formula - you would need a macro to do that.

Pete

Okay thanks for narrowing it down for me at least