Hide unhide non-contiguous columns

S

Saintsman

I use the following code to hide/unhide a range of cells using a tick box
With Columns("O:W")
.Hidden = Not .Hidden
End With

I want to do exactly the same for columns G,J,P,R ie if they are hidden then
unhide them, if they are not hidden then hide them
Any help appreciated
 
M

Mike H

Try this

If Not Range("G:G,J:J,P:p,R:R").EntireColumn.Hidden Then
Range("G:G,J:J,P:p,R:R").EntireColumn.Hidden = True
End If

Mike
 
S

Saintsman

How do I unhide them using the same control?

Mike H said:
Try this

If Not Range("G:G,J:J,P:p,R:R").EntireColumn.Hidden Then
Range("G:G,J:J,P:p,R:R").EntireColumn.Hidden = True
End If

Mike
Click to expand...
 
D

Don Guillett

Sub togglehiddencolumns()
Range("G:G,J:J,P:p,R:R").EntireColumn.Hidden = Not _
Range("G:G,J:J,P:p,R:R").EntireColumn.Hidden
End Sub
 
M

Mike H

Hi,

This makes it into a toggle of hide/unhide

If Not Range("G:G,J:J,P:p,R:R").EntireColumn.Hidden Then
Range("G:G,J:J,P:p,R:R").EntireColumn.Hidden = True
Else
Range("G:G,J:J,P:p,R:R").EntireColumn.Hidden = False
End If

Mike
 
D

Don Guillett

OR
Sub togglehiddencolumns()
With Range("G:G,J:J,P:p,R:R").EntireColumn
.Hidden = Not .Hidden
End With
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Macro to Hide/Unhide various columns 5
Hide / Unhide Columns in Password Protected w/s 2
hide-unhide 4
Show/Hide Columns 8
Identify Hidden Columns - New issue! 19
Problem Unhidding columns/rows in excel using VBA 4
Can this be done with HIDE - UNHIDE ? 4

Top