Arvi, thanks for posting this helpful 'trick' - a named range that adjusts
automatically! As one of the characters on the Guiness Stout television
commercials (running in California) would say: "BRILLIANT!!"
--
rpw


"Arvi Laanemets" wrote:

An example:
You have a list on sheet MyList (list header in cell A1, list values
starting from A2, without any gaps). Define named range Selections as
=OFFSET(MyList!$A$1,1,,COUNTA(MyList!$A:$A)-1,1)

Whenever you add entries to list, or remove some, the named range adjusts
automatically.



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )