Not farfetched Tom:

You could write a macro that would detect the zero values and set the column
widths to zero or set columnhide to true.
--
Gary's Student


"lehigh46" wrote:

Hi All,

I know this sounds a bit far fetched but, is it possible to hide
columns based on the contents of a row of cells?

ie: if columns R, S & U have zero results then hide those columns

Thank you for not laughing and thank you for your help.

Tom Snyder