| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Relative Addresses to Select Columns
I want to to select the next 5 columns after the current cell. the next 5
columns will change week by week. Absolute cell references work say Columns("Q:U").Select What I can't find a way to do is use relative addresses eg Columns("C[1]:C[6]").Select I tried variations on the syntax but all without success. All get various syntax or type mismatch errors Any ideas? regards Andrew |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Relative Addresses to Select Columns
Andrew,
try: columns("Q").resize(, 6).Select or columns(17).resize(, 6).Select HTH keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "Andrew Rallings" wrote: I want to to select the next 5 columns after the current cell. the next 5 columns will change week by week. Absolute cell references work say Columns("Q:U").Select What I can't find a way to do is use relative addresses eg Columns("C[1]:C[6]").Select I tried variations on the syntax but all without success. All get various syntax or type mismatch errors Any ideas? regards Andrew |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select range using row and column number addresses | Excel Discussion (Misc queries) | |||
| Macro - getting relative cell addresses to flow down | Excel Discussion (Misc queries) | |||
| How do I record a macro with relative cell addresses? | Excel Discussion (Misc queries) | |||
| How do I change a macro to use relative cell addresses? | Excel Discussion (Misc queries) | |||
| How do I change a Macro to use relative cell addresses? | Excel Discussion (Misc queries) | |||
Hybrid Mode
