How do you copy multiple (non-consecutive) columns using the numeric values
of the columns? In other word I am looking for code that does this:
Range("C:C,E:E,G:G").Copy
But, using numbers like this:
Columns(3,5,7).Copy €˜This doesnt work
Any ideas?

Tx,
Randall

Range("3:3,5:5,7:7").Copy

--

Vasant

"Randall" wrote in message
...
How do you copy multiple (non-consecutive) columns using the numeric
values
of the columns? In other word I am looking for code that does this:
Range("C:C,E:E,G:G").Copy
But, using numbers like this:
Columns(3,5,7).Copy 'This doesn't work
Any ideas?

Tx,
Randall

The code:

Range("3:3,5:5,7:7").Copy

copies rows not Columns. How do you do the same thing but for COLUMNS?


"Vasant Nanavati" wrote:

Range("3:3,5:5,7:7").Copy

--

Vasant

"Randall" wrote in message
...
How do you copy multiple (non-consecutive) columns using the numeric
values
of the columns? In other word I am looking for code that does this:
Range("C:C,E:E,G:G").Copy
But, using numbers like this:
Columns(3,5,7).Copy 'This doesn't work
Any ideas?

Tx,
Randall

Range("C:C,E:E,G:G").Copy

--
Regards,
Tom Ogilvy


"Randall" wrote in message
...
The code:

Range("3:3,5:5,7:7").Copy

copies rows not Columns. How do you do the same thing but for COLUMNS?


"Vasant Nanavati" wrote:

Range("3:3,5:5,7:7").Copy

--

Vasant

"Randall" wrote in message
...
How do you copy multiple (non-consecutive) columns using the numeric
values
of the columns? In other word I am looking for code that does this:
Range("C:C,E:E,G:G").Copy
But, using numbers like this:
Columns(3,5,7).Copy 'This doesn't work
Any ideas?

Tx,
Randall

Sorry; long day at work.

Probably better ways, but perhaps:

Union(Columns(3),Columns(5),Columns(7)).Copy

--

Vasant



"Randall" wrote in message
...
The code:

Range("3:3,5:5,7:7").Copy

copies rows not Columns. How do you do the same thing but for COLUMNS?


"Vasant Nanavati" wrote:

Range("3:3,5:5,7:7").Copy

--

Vasant

"Randall" wrote in message
...
How do you copy multiple (non-consecutive) columns using the numeric
values
of the columns? In other word I am looking for code that does this:
Range("C:C,E:E,G:G").Copy
But, using numbers like this:
Columns(3,5,7).Copy 'This doesn't work
Any ideas?

Tx,
Randall