Can INDIRECT be used to dynamically alter the second range reference in a Named Range

Thanks, Wyn. This has been a most interesting exchange. In my career (now retired) I was director of the HR/Payroll database at my company, and became in the process very adept at topics like data integrity (in Excel, facilitated by your data validation methods). I've used Excel data validation for a decade or more. And used most of Excel's D____ database functions. The TABLE capability per se is new to me...as you noticed, I was relying on Named Range and wanting to dynamically define the range (and now do so using OFFSET)...anyway, I miss the days of printed manuals (which I actually read periodically, to uncover ways to do things more easily than I'd been doing them). On-line references are useful, but you don't "stumble across" the unexpected. Like in this case, I didn't realize Excel had come up with new ways to conceive of and use tables. I've added your site to my reference bookmarks.