| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use variable to reference a range?
Hi
Is it possible to use a variable as part of a range reference? In the example below I want to change the value 6000 to a different value that changes from time to time. Can I substitute 6000 for x, y z etc. Range("d4:d6000").Value = 1 Any help would be gratefully received. Thanks Ritchi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to reference variable range? | Excel Discussion (Misc queries) | |||
| Variable Cell Range Reference | Excel Worksheet Functions | |||
| How do I set up a variable reference range in Excel? | Excel Programming | |||
| Variable range reference | Excel Discussion (Misc queries) | |||
| Variable Range Reference | Excel Programming | |||
Hybrid Mode
