dontasciime
New Member
- Joined
- May 25, 2010
- Messages
- 7
I am having trouble with some vba code to hide columns. I need to hide column L:M and also O:AC. Whenever I run the macro it ends up hiding column N which has to be shown. I don't know whats wrong with it. Could someone help? I am using Excel 2007. This seems so basic yet I don't know why it isn't working. I've even tried adding in a line Selection.EntireColumn.Hidden = False for column N but that doesn't work either.
Code:
Sub Condense()
Columns("L:M").Select
Selection.EntireColumn.Hidden = True
Columns("O:AC").Select
Selection.EntireColumn.Hidden = True
End Sub