Thread: Toggle Columns
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Toggle Columns

Hi Greg,

Try this,

Sub ToggleHideCols2()
Dim col As Range
For Each col In Range("D:D, J:J, L:M, P:U, X:AH").Columns
col.Hidden = Not col.Hidden
Next col

End Sub

---
Regards,
Norman



"GregR" wrote in message
ups.com...
What is wrong with this code for toggling columns. TIA

Sub ToggleHideCols2()

Columns("D:D", "J:J", "L:M", "P:U", "X:AH").Hidden = Not Columns
_("D:D", "J:J", "L:M", "P:U", "X:AH").Hidden

End Sub

Greg