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!
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!