Thanks very much.

C

"Bob Phillips" wrote:

Put the values in a range, and point the DV at that range rather then embed
them.

--
__________________________________
HTH

Bob

"Davieslondon" wrote in message
...
Hi,

I am having difficulty in adding new enteries to my data validation list,
every time I try to enter a new entry on the list it starts to over write
my
existing enteries. Does anyone know if there is a maximum number of
characters allowed per drop down!? Or does anyone know how to get around
this
problem!?

Thanks,

C