I started converting my data validation, dynamically pulled from SQL, from downloaded lists to arrays. This works very well unless the SQL data returned contains a comma. When I use the following code it populates the data validation with only the LastName. My workaround has been to list the names as "FirstName LastName" but is there some code that will allow populating an array with "LastName, FirstName" EG: with a list of values that contain a comma?
Please Login or Register to view this content.
Bookmarks