Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function addEditor() {
- var sheet = SpreadsheetApp.getActive().getSheetByName('GuestList');
- var Blank = sheet.getRange('a51').getValue().isBlank;
- for (var i = 2; Blank = true; i++){
- var Blank = sheet.getRange(2, 1, i, 1).isBlank;
- if (Blank === true){ break;
- }
- }
- var Editors = sheet.getRange(2, 1, i, 1);
- sheet.protect().addEditors([Editors]);
- }
Add Comment
Please, Sign In to add comment