View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Wilkinson Chris Wilkinson is offline
external usenet poster
 
Posts: 28
Default 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