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.

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


I tried this unsuccessfully:


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


does anybody have a suggestion please?

thanks!

[mikerickson]

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

[choubix]

thx! range works much better than columns... :)