Forum Discussion
Sheet name referencing to cell Excel Online
Hello everyone, I have a question related to referencing the tab name to a cell in excel 365 online. In the regular version of Excel, the formulas below work properly, but if the sheet is put onl...
Thanks for the reply.
I know that the formula mentioned in my post is not working in Excel Online.
That's why I am asking the community if there is a possible solution for my problem.
Office script could work, like
function main(workbook: ExcelScript.Workbook) {
let sheet = workbook.getActiveWorksheet();
sheet.getRange("A1").setValue(workbook.getName());
sheet.getRange("A2").setValue(sheet.getName());
}