PDA

View Full Version : Solved: hiding columns



choubix
07-09-2008, 06:03 PM
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
07-09-2008, 08:17 PM
Range("D:I, L:X, AA:AI, AK:HS").EntireColumn.Hidden = True

choubix
07-09-2008, 11:00 PM
thx! range works much better than columns... :)