Multiple Col. Selection

[David Fixemer]

Need a good way to select multiple columns using variables?

x=1 'column a
y=3 'column c

I would like to select column x and y but not column b?

David

 

[Trevor Shuttleworth]

David

x=1 : y=3 : union(columns(x),columns(y)).Select

Regards

Trevor

 

[Bob Phillips]

Hi David,

Range(Cells(1, x), Cells(1, y)).EntireColumn.Select

is one way

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi
one way: try
....
dim rng_1 as range
dim rng_2 as range
set rng_1 = cells(1,x).entirecolumn
set rng_2 = cells(1,y).entirecolumn
....

 

[David Fixemer]

Bob,

I believe your method gets 1, 2, and 3?

David

 

[Alan Beban]

Was it tested before posting? It selects Columns A, B and C.

Alan Beban

 

[Bob Phillips]

David,

Yes it does, I missed the bit about column b. An adaptation of the method
(not necessarily the best way) is

Range(Cells(1, x).Address & "," & Cells(1,
y).Address).EntireColumn.Select

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)