Answer the question
In order to leave comments, you need to log in
How to highlight a range in a table?
How to highlight a range in a table?
For a visual check of working with ranges, you need to select this range visually right away in the code.
I use this code
function ActivateRange() {
var ss = SpreadsheetApp.getActive();
var sheet = ss.getSheetByName('Продажи на Prom ua');
var lr = sheet.getLastRow();
sheet.getRange(1,3, lr, 5).activate();
}
Answer the question
In order to leave comments, you need to log in
Try to useflush
function (){
... < proc > ...
ActivateRange();
SpreadsheetApp.flush();
... < proc > ...
}
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question