I think the limit is the size of the sheet you are working on (65,532
rows and 256 columns in Excel 2003 and before). However, with a
validation list it would take a long time to scroll through to select
the item you want if you have such a big range - could you not
organize the data (eg alphabetically) and make use of dependent data
validation? Debra Dalgleish shows how he

http://www.contextures.com/xlDataVal02.html

Hope this helps.

Pete

On Sep 15, 12:08 am, I think I need to rephrase the question
osoft.com wrote:
Can anybody tell me the limits on the number of rows available for a
validation list and limit to the number of rows and columns in a range?