Prog. Hide range and indiv. columns?

[Guest]

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

 

[Dave Peterson]

I use this kind of syntax:

Range("C:N,P,Y:Y,W:W").EntireColumn.Hidden = True

 

[Bob Phillips]

Hi Jason,

Range("C:N,P,Y:Y,W:W").EntireColumn.Hidden = True


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Awesome thank you!

I use this kind of syntax:

Range("C:N,P,Y:Y,W:W").EntireColumn.Hidden = True