A+ for ingenuity.

I apologize for not offering that as a solution - I thought you were just
looking for the "why" of it not working the way you had it set up initially.

"Antman" wrote:

I've worked around the problem by using just one INDIRECT() formula in my
range definition, referring to a cell where I've concatenated ADDRESS(1) &
":" & ADDRESS(2); this seems to work.