-
-
Save tamirko/da69818c4ced9b71cff4ce236b9dd4bd to your computer and use it in GitHub Desktop.
| 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);} | |
| } | |
| } |
I need help to be able to jump to given row from stand-alone Google Apps Script or by visiting a link without page refresh like @seanbreckenridge's solution. I've got a chrome extension that injects a panel on top of the sheet and the extension can access the sheet through a standalone google apps script, now I want to jump to the variable row by clicking a button on that panel.
My problem is solved by adding a # to the @seanbreckenridge's URL to avoid page refresh.
https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit#gid=0&range=A30#
Just adding some input, If we have to hyperlink the cell from a sheet within same workbook, we don't have to write complete link as mentioned above, Let me suggest two easy options here;
- wherever you want to create a link, just type =HYPERLINK("#rangeid=sheet ID","sheet name"), writing Sheet Name here means that you want this name to be shown in the Cell
or - just right click on any cell, click on Insert Link, and click on the sheet where you want the link, it will work
My Youtube channel: https://www.youtube.com/user/tamirkoremu