G
G
Graun2020-02-09 01:05:54
Google Apps Script
Graun, 2020-02-09 01:05:54

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

1 answer(s)
A
Alexander Ivanov, 2020-02-10
@Graun

Try offset

...
spreadsheet.getCurrentCell().offset(1, 0).activate();

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question