Skip to content

Instantly share code, notes, and snippets.

@sanhphanvan96
Forked from tamirko/gotoCell.js
Created May 20, 2019 10:52
Show Gist options
  • Save sanhphanvan96/e95079e54ffae2eb59b18736d4019552 to your computer and use it in GitHub Desktop.
Save sanhphanvan96/e95079e54ffae2eb59b18736d4019552 to your computer and use it in GitHub Desktop.
How to go to a specific cell in a Google sheet ?
function onOpen()
{
var menuEntries = [{name: "Go to", functionName: "goToCell"}];
SpreadsheetApp.getActiveSpreadsheet().addMenu("MyUtils", menuEntries);
}
function goToCell()
{
var strRange = Browser.inputBox("Insert the required cell (e.g.: B351):", Browser.Buttons.OK_CANCEL);
if(strRange != "cancel")
{
try
{
SpreadsheetApp.getActiveSheet().getRange(strRange).activate();
}
catch(e) {Browser.msgBox(e.message);}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment