Frank, I originally set up the range by marking it and
then entering the name of the range in the NAME BOX. Them
I amended the range using the INSERT/NAME/DEFINE menus and
although the range name is here it has dissapeared from
the NAME BOX list and I get an error in the sheet that is
using the new range in calculation. Do you kno why this
is. Tks for help so far.


-----Original Message-----
Hi
use a dynamic name such as
=OFFSET($A$1,0,0,COUNTA($A:$A))

--
Regards
Frank Kabel
Frankfurt, Germany
"Gerrym" schrieb im
Newsbeitrag
...
Can I automatically increase Named Ranges as I input
data ?


.