title: Limit to size of dropdown in Excel?
body: <p>is there a limit to the number of items which can be built into a dropdown in Excel via VBA?</p>
  
  <p>I am getting an "application-defined or object-defined" error and I believe the characters in my list are perfectly fine- except I have ~530 values in my dropdown?</p>
  
  <p>EDIT: I have found out through trial and error there is a character limit of 1861 characters. Is there any work around?</p>