SHARE
TWEET

Untitled

a guest Jun 16th, 2019 62 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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++;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top