Scroll Horizontally to Cell

[Kevin -]

Using Goggle Sheets app script to make a monthly "calendar" which is 50+ columns wide. When the sheet opens I want the column representing today's date to be in the center of the screen. Is there a way to do this? getRange().activate does not work.

[Edward Ulle]

Try this.

function onOpen(e) {

  e.source.getActiveSheet().setActiveSelection("C1");  // will put the cursor in cell C1

}

[Kevin -]

Thanks, that's a great clue --  setActiveSelection.  I need to position the column with cell value TODAY in the middle of the screen (this is a wide sheet with 50+ columns). It looks like setActiveSelection will scroll right to display the cell (try "AH1" instead of "C1") to the right visible edge of the screen. I can do some math to display a column further to the right and that should put TODAY close to the middle.