Syntax for Selecting Columns in VBA

[HedgePig]

Hello

Is there a way to select columns (more than 1!) in VBA by specifying numbers rather than letters?

Instead of
Columns("B:D").Select
I would like something along the lines of
Columns(2,4).Select 'Select columns 2 through 4

I want to do it this way because I want to select columns by using a variable start position and a variable end position - and don't want to end up converting those numbers to letters in a text string.

Thank you
HedgePig

 

[wadings]

Wow, that was sweet. Thanks men.

 

[wccw]

THKS . It's help me so much.

 

[kato01]

How one would use this in a loop? Like if I have 100 columns non-consecutive to select ...

 

[Fluff]

Something like this

Sub chk()

   Dim Ary As Variant
   Dim Cnt As Long
   
   Ary = Array([COLOR=#ff0000]1[/COLOR], [COLOR=#ff0000]5[/COLOR], [COLOR=#ff0000]3[/COLOR], [COLOR=#ff0000]7[/COLOR], [COLOR=#ff0000]5[/COLOR])
   For Cnt = LBound(Ary) To UBound(Ary)
      Columns(Ary(Cnt)).Select
   Next Cnt
   
End Sub

Where the values in red are your columns