Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. function LoopThrough() {
  2. var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
  3. for (var i = 0; i < sheets.length ; i++ ) {
  4. var sheet = sheets[i];
  5. SheetPrep(sheet);
  6. }
  7. }
  8.  
  9.  
  10. function SheetPrep() {
  11. var spreadsheet = SpreadsheetApp.getActive();
  12. spreadsheet.getRange('C8').activate();
  13. spreadsheet.getActiveSheet().setColumnWidth(2, 103);
  14. spreadsheet.getRange('A1').activate();
  15. var currentCell = spreadsheet.getCurrentCell();
  16. spreadsheet.getActiveRange().getDataRegion().activate();
  17. currentCell.activateAsCurrentCell();
  18. currentCell = spreadsheet.getCurrentCell();
  19. var sheet = spreadsheet.getActiveSheet();
  20. sheet.getRange(1, 1, sheet.getMaxRows(), sheet.getMaxColumns()).activate();
  21. currentCell.activateAsCurrentCell();
  22. spreadsheet.getActiveRangeList().setBackground('#ffffff');
  23. spreadsheet.getRange('1:20000').activate();
  24. spreadsheet.getRange('1:20000').createFilter();
  25. spreadsheet.getRange('B:B').activate();
  26. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement