View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
John Keith John Keith is offline
external usenet poster
 
Posts: 172
Default select non contiguos columns by variable name

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