More than 5 years have passed since last update.

アクティブなセルの値取得

GAS
spreadsheet

Last updated at 2018-10-10Posted at 2018-10-10

function GetActiveCell() {
  var objSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var objSheet = objSpreadsheet.getActiveSheet();
  var objCell = objSheet.getActiveCell();
  Logger.log("値 : " + objCell.getValues());
  
}

メモ：暇があったらやりたいこと
セルで使える関数化
=GetActiveCell('出力セル'！A2)
みたいな
トリガーはどうするんだろ？

参照
https://qiita.com/kazuki5555/items/a74103557f753ed44096

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up