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" wrote:

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"
osoft.com wrote in
message ...
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?