Thread: Creating Ranges
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Creating Ranges

If you use relative references, the named range ends up being relative to
the active cell.

--
Rick (MVP - Excel)


"Bongard" wrote in message
...
Thank you both for your prompt responses. Can I ask why the absolutel
cell references are important for the named range?