VBA Referring To Multiple Columns

[MikeG]

I have the following code:

Columns("A:C").Select

What I want to do is to select multiple groups of columns and so I tried

Columns("A:C","E:G", "N:V").Select

but got an error.

Can anyone help?

Thanks,

MikeG

 

[Misca]

Try:

Range("A:C, E:G, N:V").Select

 

[MikeG]

Try:

Range("A:C, E:G, N:V").Select

Thanks - that did the trick.

Mike