| 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 |
| 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) | |||
Threaded Mode
