Hi there I can it to work up to AS on my macro recorder
Range( _

"D:D,G:G,I:I,L:L,N:N,Q:Q,S:S,V:V,Y:Y,AB:AB,AD:AD,A G:AG,AI:AI,AL:AL,AN:AN,AQ:AQ,AS:AS
_
).Select
Selection.EntireColumn.Hidden = True
Range("A1").Select

I recorded this from the macro recorder, don't have time to do all th
columns there may be a glitch after that, maybe record in again bu
only hide 10 columns at a time so you can have more contro

--
davesexce
-----------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...fo&userid=3170
View this thread: http://www.excelforum.com/showthread.php?threadid=51777