VB Code to Hide Columns

**Angel007** · 08-17-2011, 05:39 AM

Hi there,

I am very new to VB coding in Excel so would really appreciate your expertise on this

I have a spreadsheet where I am hiding certain columns (all on the same worksheet) when a checkbox is ticked, I managed to get it working where there are consecutive columns using the below code:

Private Sub DomainRequestorColumns_Click()

If Range("C:S").EntireColumn.Hidden = True Then
Range("C:S").EntireColumn.Hidden = False
Else
Range("C:S").EntireColumn.Hidden = True
End If

End Sub

This works perfectly but I need to add a column AU and I can't for the life of me figure out how to do this?

Can you perhaps advise me on how I can do this please?

Thanks in advance,
Angela

**Steffen Thomsen** · 08-17-2011, 05:51 AM

Hi,

You need to read the forum rules, and add code brackets around your code

You just need to change to this:

Please Login or Register  to view this content.

Steffen Thomsen

**snb** · 08-17-2011, 05:55 AM

or only this oneliner:

Please Login or Register  to view this content.

**Angel007** · 08-17-2011, 07:25 AM

Originally Posted by Steffen Thomsen

Hi,

You need to read the forum rules, and add code brackets around your code

You just need to change to this:

Please Login or Register  to view this content.

Steffen Thomsen

Sincere apologies Steffen - will definately remember this next time I post a thread with code.

Thank-you very much for your reply and resolution (Steffen & snb) - tested recommended solutions and works perfectly.
Thanks again for the help and prompt response - much appreciated.

Kind Regards,
Angela

**Steffen Thomsen** · 08-17-2011, 07:32 AM

Hi Angela,

If your question has been solved then the forum rules state that you need to do the following:

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

Sincerely

Steffen Thomsen