View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Snidow Greg Snidow is offline
external usenet poster
 
Posts: 153
Default Use column number in a range instead of column letter

Greetings. How can I use a column number in a range, instead of column
letters? For example, I have Range("B3:B7").Select. I want to copy and
paste this range in another place in the worksheet, then run some other code,
and then copy Range("C3:C7") and run some code, all the way up to
Range("M3:M7"). I would like to be able to use a variable for the column
index, then just increment it by 1 at the end of the loop. Any ideas? Thank
you.