Grouping Columns causing errors with other macros

[Glove_Man]

G'Day all,

I have a macro which downloads some data into some pre-arranged cells and then formats some graphs which are linked to those cells.

Since I need to display the resultant graphs in a weekly presentation, I have grouped the columns where the data is downloaded (A to AB).

The idea is that I will hide the data when I make the presentation. However, if you run the macro with the columns hidden, you receive errors. When the columns are not hidden, you don't.

Essentially, what is the command that unhides the columns?

Is it something like:
Columns("A:AB").unhide
or
Groups("Group1").visible = true

Thanks

Philby

 

[Datsmart]

Add your lines of code to ungroup your columns to your download and format code. Then at the end, add the lines of code to re-group your columns.

 

[Glove_Man]

I got it to work, thanks.

But does anyone know if there's a way to control the +/- buttons you get along the top of the spreadsheet from inside VBA?

Philby

 

[Datsmart]

This code is for Grouping and ungrouping ROWs. Columns should be similar;

    ActiveSheet.Outline.ShowLevels RowLevels:=2
    ' or
    ActiveSheet.Outline.ShowLevels RowLevels:=1

 

[Glove_Man]

Perfect. Got it working now. Thanks.

Philby