creating a new Named Range in Excel for the web is not Possible ?

Copper Contributor

 Creating a new Named Range in Excel for the web is not possible?

3 Replies
No sadly, they haven't added this feature to the web version yet. Seems like something they may add in the future. You can create named ranges in the desktop version and refer to them online, just can't create them online.
I assume it must be possible using TypeScript automation? On the desktop, I often use VBA to upload formulas to Names; especially LAMBDA functions which can easily grow to include many statements.

@Peter Bartholomew 

Yes, in simplest case it's as

function main(workbook: ExcelScript.Workbook) {
	let sheet = workbook.getWorksheets()[0];
	let name = sheet.addNamedItem("myName", "=A1:A5");
}