View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Saintsman Saintsman is offline
external usenet poster
 
Posts: 81
Default Hide unhide non-contiguous columns

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