Guest User

Untitled

a guest
Mar 20th, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. function addEditor() {
  2. var sheet = SpreadsheetApp.getActive().getSheetByName('GuestList');
  3. var Blank = sheet.getRange('a51').getValue().isBlank;
  4. for (var i = 2; Blank = true; i++){
  5. var Blank = sheet.getRange(2, 1, i, 1).isBlank;
  6. if (Blank === true){ break;
  7. }
  8. }
  9. var Editors = sheet.getRange(2, 1, i, 1);
  10. sheet.protect().addEditors([Editors]);
  11. }
Add Comment
Please, Sign In to add comment