Edwin_Straver
Feb 16, 2022Copper Contributor
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