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?