Cursor At Last Edit Cell in Spreadsheet

[Swapnil Naik]

Hello,

I am looking for a script, which will automatically keep the cursor at position of Last edit.

Kindly suggest

[Web Dev]

Google Apps Script doesn't support the cursor and its position in Google Sheets. It does have such support in Google Docs, however:

https://developers.google.com/apps-script/reference/document/position

As for Google Sheets you can implement  the following:

1) Use PropertiesService to cache your data set (sheet name and range) in the memory onEdit()

2) Use PropertiesService to retrieve and apply the info onOpen()

function onOpen() {

const ss = SpreadsheetApp.getActiveSpreadsheet();

const rangePosition = PropertiesService.getUserProperties().getProperty('lastEditPosition');

if (rangePosition) {

rangePosition = JSON.parse(rangePosition);

ss.setActiveSheet(ss.getSheetByName(rangePosition.lastEditSheet));

ss.setActiveRange(ss.getRange(rangePosition.lastEditRange));

}

}

function onEdit(e) {

const range = e.range;

const sheet = range.getSheet();

PropertiesService.getUserProperties().setProperty('lastEditPosition', JSON.stringify({

lastEditSheet: sheet.getName(),

lastEditRange: e.range.getA1Notation(),

}));

}