Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onOpen(e) {
- var spreadsheet = e.source;
- var sheet = spreadsheet.getActiveSheet();
- var row = 222;
- while (true) {
- var range = sheet.getRange("L" + row);
- if (!range.getValue()) {
- sheet.setActiveRange(range);
- return;
- }
- row++;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement