Macro to group/hide columns

[icsupt]

I want to create a macro that will group columns F & G and columns J & K - all at the same time.

This worksheet has the "Forecast" and "Actual" numbers. So when the macro is run, it will only show columns A-E and columns H-I, and any columns pass column K (these are the "Forecast" numbers). It should either hide or group columns F, G, J, K (these are the "Actual" numbers).

Then I want to be able to have another macro ungroup everything on the worksheet.

Is there a way to do this?

Thanks in advance.

 

[SkipVought]

Hi,

Are you referring to

Data/Group & Outline

or

Hiding & Unhiding Columns?

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[icsupt]

Either way would be fine -- I tried both and neither worked.

 

[SkipVought]

Well each does a different thing.

What are you trying to do and

how did you try to do it?

Please explain in excruciating detail!

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}