VBA select two columns using column numbers

[xluser7]

Hi:

I'd like to be able to select two columns at the same time (not the columns between them - only those two columns) given that I have two integers that locate those two columns.

Thanks!

 

[Beyond_avarice]

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

 

[Norie]

Try this.

Dim col1 As Long
Dim col2 As Long

    col1 = 10
    col2 = 15

    Union(Columns(col1), Columns(col2)).Select

 

[xluser7]

Thanks, Norie - that answered my question!

 

[excelakos]

Try this.

Dim col1 As Long
Dim col2 As Long

    col1 = 10
    col2 = 15

    Union(Columns(col1), Columns(col2)).Select

Hi Norie!! What is needed in the code you provided in order to select columns in a pivot table?