Data Validation...I need to add more entries!!

[Davieslondon]

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

 

[Bob Phillips]

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

 

[Max]

I wonder if its because you're typing items directly into the DV's source box?

You could try the other options (eg: named/defined range) in Debra's page:
http://www.contextures.com/xlDataVal01.html
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik

 

[Davieslondon]

Thanks very much.

C

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

--
__________________________________
HTH

Bob

 

[Davieslondon]

I think it was, but have now resloved the issue.

Thank you.