NamedRange referring to another Named Range

Question

Let's say I have two named ranges:

• LEFT=A1:C4
• RIGHT=X1:X5

Can a named range refer to other named ranges? Or does the named range evaluate to whatever cells it refers to at runtime? In other words, if I were to select both of the above ranges and try and do:

• ALL=LEFT,RIGHT

The runtime evaluation would be:

• ALL=A1:C4,X1:x5

Or how exactly would this work, and can named ranges refer to previously-defined named ranges, i.e., be indirectly or recursively defined?

Answer 1

It works for me exactly as you described it.