| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
syntax - range name as a variable
I can select a named range like so : range ("range_01").select this works. but I want to make the selected range a variable like this: range_string = "range_01" range (range_string).select This gives me error messages "method range of object global failed" What is the correct syntax for doing this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting a range of rows based on a variable; syntax error | Excel Discussion (Misc queries) | |||
| macro syntax for selecting variable range | Excel Discussion (Misc queries) | |||
| syntax when using a variable in a formula | Excel Programming | |||
| syntax for variable | Excel Programming | |||
| Syntax to Set variable range | Excel Programming | |||
Threaded Mode
