【GAS】シートを開いたときに特定のセルを検索しアクティブにする方法(Gスプレッドシート)

function onOpen() {
  // function testactive() {
  const ss = SpreadsheetApp.getActiveSpreadsheet()
  const sh = ss.getSheetByName('横並び').activate()


  let today = new Date()
  // today = Utilities.formatDate(today,'JST','yyyy/MM/dd')
  today = Utilities.formatDate(today, 'JST', 'yyyy年M月d日')
  console.log(today)


  let textFinder = sh.createTextFinder(today);//テキストの検索
  let ranges = textFinder.findAll();


  if (ranges.length > 0) {
    ranges[0].activate()
  }


  // let ncont = ranges.length;//個数の取得
  // console.log( "個数=",ncont);
  // for( i=0;i<ncont;i++){
  // console.log( ranges[i].getA1Notation());
  // ranges[i].activate()
  // }


  console.log(ranges[0].getRow())
  sh.getRange(ranges[0].getRow(), 7).setValue(today)


}