Advertisement
Guest User

Untitled

a guest
Jul 17th, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. function deleteRows() {
  2. var ss = SpreadsheetApp.getActiveSpreadsheet();
  3. var s = ss.getSheetByName('Copy of TBC Sort');
  4. var r = s.getRange('C3:C400');
  5. var v = r.getValues();
  6. for(var i=v.length-1;i>=0;i--)
  7. if(v[0,i]=='Delete Row')
  8. s.deleteRow(i+1);
  9. };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement