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