Ok, try this:

Hold down the CTRL key and hit the F3 key, this will bring out the
Define name box, select "employeeslist" from the list then check out
the "Refers to" box at the bottom, enlarge your range by ajusting the
last parameter

e.g.
=Sheet1!$D$6:$E$20
to
=Sheet1!$D$6:$E$30

that would add 10 rows to the list

then hit OK. You should now be able to add to the list, try that and
let me how it goes.

Regards
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=495300