Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function LoopThrough() {
- var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
- for (var i = 0; i < sheets.length ; i++ ) {
- var sheet = sheets[i];
- SheetPrep(sheet);
- }
- }
- function SheetPrep() {
- var spreadsheet = SpreadsheetApp.getActive();
- spreadsheet.getRange('C8').activate();
- spreadsheet.getActiveSheet().setColumnWidth(2, 103);
- spreadsheet.getRange('A1').activate();
- var currentCell = spreadsheet.getCurrentCell();
- spreadsheet.getActiveRange().getDataRegion().activate();
- currentCell.activateAsCurrentCell();
- currentCell = spreadsheet.getCurrentCell();
- var sheet = spreadsheet.getActiveSheet();
- sheet.getRange(1, 1, sheet.getMaxRows(), sheet.getMaxColumns()).activate();
- currentCell.activateAsCurrentCell();
- spreadsheet.getActiveRangeList().setBackground('#ffffff');
- spreadsheet.getRange('1:20000').activate();
- spreadsheet.getRange('1:20000').createFilter();
- spreadsheet.getRange('B:B').activate();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement