I developed a desktop Excel Add-in to perform tasks based on selected cells, eg: change cell style, pop up a dialog, toggle formulas. Range name is used to determine the various tasks.
For example in VBA, Range("A1").Name.Name or ActiveCell.Name.Name to return its range name "Sheet1!Year".
However, range name is not available in Office Add-in which makes it difficult to work around this.
https://docs.microsoft.com/en-us/javascript/api/excel/excel.range?view=excel-js-online
No CommentsBe the first to comment