SHARE
TWEET

Untitled

a guest Jun 16th, 2019 55 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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. }
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top