View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Data Validation...I need to add more entries!!

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