Is there a limit to the number of items that can appear in a data validation
drop-down? My source list can grow to be up to 1500 items long, and I don't
see any information in excel help or on this board about whether the
resulting data validation drop-down will be able to handle so many items.

TIA

Why bother with DV. The quick way is just type it in a cell instead of
looking through the long list of DV


"andy62" wrote:

Is there a limit to the number of items that can appear in a data validation
drop-down? My source list can grow to be up to 1500 items long, and I don't
see any information in excel help or on this board about whether the
resulting data validation drop-down will be able to handle so many items.

TIA

Don't believe there is a limit.
I stopped at creating one to 11,000 items (rows) without any problem.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"andy62" wrote in message
...
Is there a limit to the number of items that can appear in a data
validation
drop-down? My source list can grow to be up to 1500 items long, and I
don't
see any information in excel help or on this board about whether the
resulting data validation drop-down will be able to handle so many items.

TIA

The range limit is 32,767 cells in a 1 dimensional array (single column or
row).

If you type in the items as a comma delimited array then the limit is ~255
characters.

Biff

"andy62" wrote in message
...
Is there a limit to the number of items that can appear in a data
validation
drop-down? My source list can grow to be up to 1500 items long, and I
don't
see any information in excel help or on this board about whether the
resulting data validation drop-down will be able to handle so many items.

TIA