OPTIONS.LISTS.ADD

Macro Sheets Only

This is the equivalent to choosing the Options command from the Tools menu and then selecting the Custom Lists tab in the Options dialog box. Used to add a new custom list.

Syntax

OPTIONS.LISTS.ADD(string_array)
OPTIONS.LISTS.ADD(import_ref, by_row)
OPTIONS.LISTS.ADD?(import_ref, list_num)

String_array is an array of strings or cell reference that contains the custom items in the list, a named cell reference, or an external reference containing the items of the custom list to add.

Import_ref is the reference to the cells that contain the members of the custom list. If A1:A12 contains the twelve signs of the Zodiac starting with Aquarius, then this function will add the contents of these twelve cells as a custom list.

By_row is a logical value that if TRUE, and if importing from cells, assumes that the list items are in sequential rows. If FALSE, assumes that the list items are in columns. If omitted, Microsoft Excel will try to determine the order of the custom lists according to the layout of the sheet.

List_num is a number specifying which list to activate. If omitted, then New List will be activated.

Remarks

• To replace an existing custom list, you must first delete it and then add the new list to the end.
• If the list already exists, then this function will do nothing. The list is not case sensitive, so "Scorpio" and "scorpio" are treated the same in custom lists.

Related Functions

OPTIONS.VIEW Sets various view settings

OPTIONS.LISTS.GET Returns contents of custom AutoFill lists

OPTIONS.LISTS.DELETE Deletes a custom list

List of Command-Equivalent Functions