View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
andy62 andy62 is offline
external usenet poster
 
Posts: 158
Default Data validation list limit?

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