This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function checkCell() { | |
// スプレッドシートを指定 | |
var spreadshseet = SpreadsheetApp.openById('***********') | |
var numSheets = spreadshseet.getNumSheets(); | |
//チェックする文字列を定義 | |
var reg = "NG【要確認】"; | |
loop: | |
for(var sheetNo = 0; sheetNo <= numSheets-1; sheetNo++) { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function JumpToDefinition() { | |
// 現在のスプレッドシートを取得 | |
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); | |
// 現在のシートを取得 | |
var sheet = spreadsheet.getActiveSheet(); | |
// 参照元のセルの位置を取得する | |
var value = sheet.getCurrentCell().getFormula().replace("=",""); | |
//該当のセルに移動する | |
var objRange = sheet.getRange(value); |