function onOpen() {
var ui = SpreadsheetApp.getUi();
ui.createMenu('Go To')
.addItem('Cell A1', 'goToA1')
.addItem('Cell B1', 'goToB1')
.addToUi();
}
function goToA1() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var cell = sheet.getRange("A1");
sheet.setActiveRange(cell);
}
function goToB1() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var cell = sheet.getRange("B1");
sheet.setActiveRange(cell);
}
Asked: 2023-01-04 11:00:00 +0000
Seen: 17 times
Last updated: Sep 22 '22