Named ranges with dependencies
In , Roger Govier
spake thusly:
Hi Dallman
Obtw: what's the advantage to having "List" with all the
column headers rather than matching on Row 1 itself?
None really, except that I don't usually have my headers on
Row 1 and, I much prefer using named ranges to row or column
references. I nearly always leave 5 rows free at the top of
any sheet I am setting up, in case I want to use them for other
things e.g. placing subtotals there.
Okay, I'm with you. Thanks very much for the good explanations
and help!
Dallman
|