VBA Expand/Collapse grouped columns based on cell value

[jasonwhittin]

Hi All,

I'm hoping to obtain VBA code to expand /collapse grouped columns if a cell contains any number / is empty.

For example - if cell A1 contains any number, expand grouped columns (B through D). If cell A1 does not contain a value, collapse grouped columns (B through D).

Thanks!

[Artik]

The important thing is, is A1 the result of the formula or do you enter the value manually?

Artik

[jasonwhittin]

Hi Artik,

The number in A1 is resulting from a formula.

Thanks,

Jason.