Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. function onOpen(e) {
  2. var spreadsheet = e.source;
  3. var sheet = spreadsheet.getActiveSheet();
  4. var row = 222;
  5. while (true) {
  6. var range = sheet.getRange("L" + row);
  7. if (!range.getValue()) {
  8. sheet.setActiveRange(range);
  9. return;
  10. }
  11. row++;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement