Thread: Creating Ranges
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Creating Ranges

Take a look at this when you get a chance:
http://www.cpearson.com/excel/named.htm

Also, this is an overall good tutorial:
http://www.anthony-vba.kefra.com/vba/vbabasic2.htm

HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Rick Rothstein" wrote:

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?