View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
luvgreen luvgreen is offline
external usenet poster
 
Posts: 33
Default How to select columns using column index

Thank you so much for answering my question. It worked great!

"Dave Peterson" wrote:

How about:

range("d:k").select
or
range(Columns(4),columns(11)).select
or
columns(4).resize(,8).select



luvgreen wrote:

Greetings! I would like to select column D to K. Instead of using
Columns("D:K").select, I tried Columns("4:11").select. It did not work. How
can I make it work if I only know the column index? Thanks.


--

Dave Peterson