There was only delete -r to delete named range and regular data range variables. New -rn option is added to delete named ranges only.

Syntax

delete -rn [name] [scope] /// name support wildcard, scope can be 0(Sheet), 1(Book), 2(Project)

Number of Named Range deleted will be dumped after executing it.

Examples:

• del -rn //delete all named ranges in project

• del -rn alpha* 1 //delete all named ranges in book scope starting with alpha

Tip: Use list -rn to view existing named ranges.