Validation length, Range length

[Guest]

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?

 

[Pete_UK]

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 here:

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

Hope this helps.

Pete

 

[T. Valko]

A data validation list can contain up to 32,767 items.

and limit to the number of rows and columns in a range?

If you mean the size of a referenced range there is no limit (although there
are some limits imposed by certain functions and formula usage).

See this:

http://support.microsoft.com/kb/166342

--
Biff
Microsoft Excel MVP


"I think I need to rephrase the question"

 

[Guest]

Scrolling through the list is fast as I can jump large increments. I am
referencing a large database of information. Thanks for the advice

 

[Guest]

I tested the validation and came up with the same row number. The range size
is handy to know for my data referencing. Thanks for the information.

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP


"I think I need to rephrase the question"