Easier way to select multiple columns in excel

[ERed1]

Hi all,

So I am writing a code to select multiple columns. Here is what my code would look like:

Columns("B:B")...
 Columns ("E:E")...
 Columns ("H:H")...

Is there an easier way of selecting all of those with only one "Columns"? The ... is there just for the example.

Thanks in advance.

 

[Joe4]

Try:

Range("B:B, E:E, H:H").Select

 

[ERed1]

Thanks for the help. That worked.

 

[Joe4]

You are welcome.