Answer the question
In order to leave comments, you need to log in
How to go down one cell after finding the last filled one?
I can’t figure out how to add here to go down one cell below the one found ???
function posledyaheika() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('C1').activate();
spreadsheet.getCurrentCell().getNextDataCell(SpreadsheetApp.Direction.DOWN).activate();
};
Answer the question
In order to leave comments, you need to log in
Try offset
...
spreadsheet.getCurrentCell().offset(1, 0).activate();
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question