| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to select columns using column index
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to select columns using column index
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
| =INDEX($B$2:$P$2,COLUMNS(B$2:$P$2)) | Excel Discussion (Misc queries) | |||
| How do you select line or columns in "Line-Column on 2 axes" graphs? | Excel Discussion (Misc queries) | |||
| INDEX() columns first | Excel Worksheet Functions | |||
| Problem using INDEX to select items in listbox | Excel Discussion (Misc queries) | |||
Linear Mode
