Edwin_Straver's avatar
Edwin_Straver
Copper Contributor
Feb 16, 2022
Status:
New

Allow Add in the name collection to refer to a rangeArea, not just a range

Currently, the Add method on the names collection:

 

add(name: string, reference: Range | string, comment?: string): Excel.NamedItem;

 

allows a reference that points to a range, but not a rangeAreas object. This means you can not create a defined name, that points to, for example: A1:A10, B1:B5. (A selection of multiple ranges).

This seems an unnecessary limitation.

 

Edwin

No CommentsBe the first to comment