Range Names : Good or Bad programming practice?

[Bob Phillips]

I also recently ran into a surprising problem with dynamic named ranges:

http://www.experts-exchange.com/Appl..._21414425.html

Patrick,

It is not so surprising, just think about what a dynamic range name. By virtue of the fact that you are using OFFSET, you are returning an array of values not a range.

The INDIRECT function accepts ranges or strings that evaluate to a range, such as A2:A100, but not an array such as {1,2,3}.

QED - the two do not go together.