Code to switch views of columns

[ExcelRoy]

Hi all,

I ma trying to generate a macro that when run will offer me certain columns to view and hide unnecessary columns

I have run the following using the macro recorder but this doesn't seem to worknymore

Sub View_Meeting()

    Columns("A:E").Select
    Selection.EntireColumn.Hidden = False
    Columns("F:FS").Select
    Selection.EntireColumn.Hidden = True
    Range("A1").Select
    
End Sub

This was working before I made some changes to the workbook but none of the changes are code changes

Would there a be a more robust option available, or a better written code option maybe?

many thanks

 

[Fluff]

Do you have any merged cells?

 

[ExcelRoy]

Hi Fluff,

yes, I do!
Is there a way to include this into new code?

Thanks

 

[Fluff]

Try

Sub View_Meeting()
    Columns("A:E").Hidden = False
    Columns("F:FS").Hidden = True
    Range("A1").Select
End Sub

but it's best to avoid merged cells like the plague. They'll only comeback to haunt you.

 

[ExcelRoy]

Great, many thanks Fluff

 

[Fluff]

You're welcome & thanks for the feedback