I have integer variables that define several columns of interest in a
worksheet. How do I select multiple non contiguous columns?

Example

parts = 3 ' column 3 has parts info
dates = 6 ' column 6 has date info
cost = 10 ' column 10 has cost info

columns(parts, dates, cost).Select this statement does not work

TIA


John Keith

Hi,

Try this :

Range("parts, dates, cost").Select




"John Keith" a écrit dans le message de groupe de discussion :
...
I have integer variables that define several columns of interest in a
worksheet. How do I select multiple non contiguous columns?

Example

parts = 3 ' column 3 has parts info
dates = 6 ' column 6 has date info
cost = 10 ' column 10 has cost info

columns(parts, dates, cost).Select this statement does not work

TIA


John Keith

With ActiveSheet
Union(.Columns(parts), .Columns(dates), .Columns(cost)).Select
End With

But remember, it's very rare where you actually have to select a range to work
with it.

John Keith wrote:

I have integer variables that define several columns of interest in a
worksheet. How do I select multiple non contiguous columns?

Example

parts = 3 ' column 3 has parts info
dates = 6 ' column 6 has date info
cost = 10 ' column 10 has cost info

columns(parts, dates, cost).Select this statement does not work

TIA


John Keith


--

Dave Peterson

On Sat, 23 Jan 2010 17:55:31 -0500, "michdenis"
wrote:

Try this :

Range("parts, dates, cost").Select

I did try that and it did not work. But thank you for looking.


John Keith

On Sat, 23 Jan 2010 18:14:27 -0600, Dave Peterson
wrote:

With ActiveSheet
Union(.Columns(parts), .Columns(dates), .Columns(cost)).Select
End With

But remember, it's very rare where you actually have to select a range to work
with it.

Dave,

Thank you that worked perfectly. And yes, I was able to merge the next
line that began Selection.

What are the pros/cons to using Select?


John Keith

The cons are that you have to select something to work with it. The code is
difficult to read/modify.

The pros are that you can use what the macro recorder gave you. But that
recorded macro is probably very messy to understand.

John Keith wrote:

On Sat, 23 Jan 2010 18:14:27 -0600, Dave Peterson
wrote:

With ActiveSheet
Union(.Columns(parts), .Columns(dates), .Columns(cost)).Select
End With

But remember, it's very rare where you actually have to select a range to work
with it.

Dave,

Thank you that worked perfectly. And yes, I was able to merge the next
line that began Selection.

What are the pros/cons to using Select?

John Keith


--

Dave Peterson

| I did try that and it did not work. But thank you for looking.

Range("parts, dates, cost").Select

*** it works if "parts", "dates" and "cost" are names not variables
representing a column number as it was the case in your question.
I simply misinterpreted your request !




John Keith

On Mon, 25 Jan 2010 23:12:54 -0500, "michdenis"
wrote:


| I did try that and it did not work. But thank you for looking.

Range("parts, dates, cost").Select

*** it works if "parts", "dates" and "cost" are names not variables
representing a column number as it was the case in your question.
I simply misinterpreted your request !

Ah, thank you. Someday I'm going to use range names and I'll add this
to my bag of tricks.


John Keith