Hi


"D.Farns" wrote in message
...
Arvi, no reason really. I'm still a bit of a "newby" in the Excel object
model. I'm using named ranges elsewhere and found to be a pain redefining
the name when it changes is size. I do see that using Names is

This is for what dynamic named ranges are used.

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 )