Prog. Hide range and indiv. columns?
Is it possible to hide a range of columns programatically as well as
additional free floating columns elswhere on the work sheet.
For instance, this hides a range::
Columns("C:N").Select
Selection.EntireColumn.Hidden = True
But, what I really want to achieve is this:
Columns("C:N, P, Y, W").Select
Selection.EntireColumn.Hidden = True
....Of course, this throws up an error...is there a way to rephrase this code
to make it do what I want?
Many thanks
Jason
Excel 2000
|