Quote Originally Posted by Cyberdude
With all the conversation going on, I started getting a little confused about what's being called a "named range". I think the term range is what's bothering me.
You are right, they are just called Names in help. They apply to a workbook or a worksheet. They do not apply to ranges, just are most often use to ReferTo a range.

Quote Originally Posted by Cyberdude
In fact all defined names are formulas,
No, names can refer to a constant value.