I'm trying to adjust this code so that I can jump to today's date which are all across row 2 in my spreadsheet.
function onOpen() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
var range = sheet.getRange("A:A");
var values = range.getValues();
var day = 24*3600*1000;
var today = parseInt((new Date().setHours(0,0,0,0))/day);
var ssdate;
for (var i=0; i<values.length; i++) {
try {
ssdate = values[i][0].getTime()/day;
}
catch(e) {
}
if (ssdate && Math.floor(ssdate) == today) {
sheet.setActiveRange(range.offset(i,0,1,1));
break;
}
}
}
this answer is from Marshmallow
I tried changing sheet.getRange("A:A")
to sheet.getRange("2:2")
and sheet.getRange("C2:PB2")
but neither work.
Best Answer
try this code:
What was changed:
sheet.getRange("2:2");
as you didvalues = values[0];
get the first row of datasheet.setActiveRange(range.offset(0,i,1,1));
offset on columns