Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Defining a range using defined names
Hi I have a range that that starts at
$A$2 which is named "dataStart" and ends with $A$10 which is named "DataEnd". I want to create a named range using the defined names, e.g dataList refers to =dataStart:DataEnd except that the above syntax does not work. can someone tell me the correct syntax for this, as I don't want to use =$A$2:$A$10. The values for dataStart and dataEnd may change which is why I do not want to hard code them. Thanks, Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Defined Range Names in formulas | Excel Discussion (Misc queries) | |||
Help defining a user-defined function | New Users to Excel | |||
Rename Several Defined Range Names with Macro | Excel Programming | |||
Listing or Changing all Defined Range Names (using VBA) | Excel Programming | |||
Defining worksheet specific range names | Excel Programming |