Solved: hiding columns

[choubix]

hello,

I am trying to hide a selection of columns. I currently am using that code but I believe there is a better way of addressing the problem.

[VBA]Columns("D:I").Select
Selection.EntireColumn.Hidden = True
Columns("L:X").Select
Selection.EntireColumn.Hidden = True
Columns("AA:AI").Select
Selection.EntireColumn.Hidden = True
Columns("AK:HS").Select
Selection.EntireColumn.Hidden = True[/VBA]


I tried this unsuccessfully:
[VBA]

'Columns("D:I, L:X, AA:AI, AK:HS").Select
'Selection.EntireColumn.Hidden = True
[/VBA]

does anybody have a suggestion please?

thanks!

[mikerickson]

[VBA]Range("D:I, L:X, AA:AI, AK:HS").EntireColumn.Hidden = True[/VBA]

[choubix]

thx! range works much better than columns...