Macro Sheets Only
Returns contents of custom AutoFill lists as an array of text strings.
Syntax
OPTIONS.LISTS.GET(list_num)
OPTIONS.LISTS.GET(string_array)
List_num is a number specifying which list to return, as a horizontal string array. If list_num is zero, then FALSE is returned.
String_array is an array or cell reference to store the returned list.
Example
OPTIONS.LIST.GET(3) returns the twelve months of the year in the form {"Jan", "Feb", "Mar"}
Remarks
If list_num is zero or omitted, then FALSE is returned.
Related Functions
OPTIONS.LISTS.ADD Adds a new custom list
OPTIONS.LISTS.DELETE Deletes a custom list
OPTIONS.VIEW Sets various view settings
List of Information Functions