相対参照マクロ

/** @OnlyCurrentDoc */

function myFunction() {
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.getRange('A1').activate();
  spreadsheet.getCurrentCell().setValue('1');
  spreadsheet.getRange('B2').activate();
  spreadsheet.getCurrentCell().setValue('2');
  spreadsheet.getRange('C3').activate();
  spreadsheet.getCurrentCell().setValue('3');
  spreadsheet.getRange('C4').activate();
};

function myFunction1() {
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.getCurrentCell().setValue('1');
  spreadsheet.getCurrentCell().offset(1, 1).activate();
  spreadsheet.getCurrentCell().setValue('2');
  spreadsheet.getCurrentCell().offset(1, 1).activate();
  spreadsheet.getCurrentCell().setValue('3');
  spreadsheet.getCurrentCell().offset(1, 0).activate();
};