Advertisement
RUZBE

Pyrgos - insertRow

Feb 17th, 2019
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function insertRow() {
  2.   var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  3.   var OCreport = spreadsheet.getSheetByName("OC Reports");
  4.   var lastRow = OCreport.getLastRow();
  5.   var clearrange = OCreport.getRange("D" + lastRow + ":M" + lastRow);
  6.   clearrange.setBorder(null, true, false, true, null, null);
  7.   OCreport.insertRowAfter(lastRow);
  8.   var lastRow = lastRow + 1;
  9.   var setBoaderStyle = OCreport.getRange("D" + lastRow + ":M" + lastRow);
  10.   setBoaderStyle.setBorder(true, null, null, null, true, true, null, SpreadsheetApp.BorderStyle.DASHED);
  11.   setBoaderStyle.setBorder(null, true, true, true, null, null);
  12.   var setFormula = OCreport.getRange("E" + lastRow).setFormula("=IFERROR(VLOOKUP(D" + lastRow + ",nameConFig!$A$1:$B$63,2,FALSE),\"Select Rank\")");
  13.   OCreport.setRowHeight(lastRow, 130);
  14. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement