Button to toggle Hide/Show multiple columns

Hi I am new to VBa and trying to have a button that toggles hide/show certain columns at once.

The columns I would like otthide are AL, BD-BE-BF-BG

Please Login or Register  to view this content.

I did this to hide AL as a start, it works but when I paste that 4 more times replacing AL for BD, then BE, etc.. the macro implodes my spreadsheet. Clearly this isn't efficient or proper way

Can anyone suggest me a code to Hide/Show those columns upon click of a button.

Thanks in advance!

I think that you need to use EntireColumn rather than EntireRow

Or, to do all the columns

Please Login or Register  to view this content.

Wasn't familiar witht he the With statement, this works great thank you very much everyone

Glad we could help & thanks for the feedback