Macro to expand groups (columns)?

[lulu840]

I'm self-taught in excel and so still have much to learn and have never used macros before. I want to add a button that expands columns B through E (The button will be in column A). Can someone please help me with how to do this?

 

[zero269]

I'm self-taught in excel and so still have much to learn and have never used macros before.

The best way to start in my opinion is to record some simple macros and review the code it creates.
From there, check out the free course on Excel VBA here. The Beginner course in the Playlist will give you a very solid starting point.

However, the Excel Workbook must be saved as a Macro-enabled Workbook if not one already. From there you can use the following VBA code I got by recording a macro where I unhid Columns B:E:

Sub UnhideB2E()
    Columns("A:F").Select
    Selection.EntireColumn.Hidden = False
    Range("A1").Select 'This line just selects cell A1 in order to deselect the Columns
End Sub

As for creating buttons and assigning macros to them...YouTube is really your best option as there are many possibilities.
That course I linked above covers everything you need to both record a macro, create buttons/shapes/objects and assign macros to them.

Best of luck...

 

[Burrgogi]

The best way to start in my opinion is to record some simple macros and review the code it creates.
From there, check out the free course on Excel VBA here. The Beginner course in the Playlist will give you a very solid starting point.

However, the Excel Workbook must be saved as a Macro-enabled Workbook if not one already. From there you can use the following VBA code I got by recording a macro where I unhid Columns B:E:

Sub UnhideB2E()
    Columns("A:F").Select
    Selection.EntireColumn.Hidden = False
    Range("A1").Select 'This line just selects cell A1 in order to deselect the Columns
End Sub

Unhiding has nothing to do with expanding a column that has a data grouping.

 

[Burrgogi]

I'm self-taught in excel and so still have much to learn and have never used macros before. I want to add a button that expands columns B through E (The button will be in column A). Can someone please help me with how to do this?

Try this:

Sub Expand_Grouping()
    ActiveSheet.Columns(2).ShowDetail = True
End Sub

Also, how to assign a macro to a button.

Add a Button and Assign a Macro in Excel

Excel Buttons In Excel, Buttons are used to call Macros. This tutorial will cover how to create Excel buttons, assign Macros to them, adjust their

www.automateexcel.com