Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function insertRow() {
- var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
- var OCreport = spreadsheet.getSheetByName("OC Reports");
- var lastRow = OCreport.getLastRow();
- var clearrange = OCreport.getRange("D" + lastRow + ":M" + lastRow);
- clearrange.setBorder(null, true, false, true, null, null);
- OCreport.insertRowAfter(lastRow);
- var lastRow = lastRow + 1;
- var setBoaderStyle = OCreport.getRange("D" + lastRow + ":M" + lastRow);
- setBoaderStyle.setBorder(true, null, null, null, true, true, null, SpreadsheetApp.BorderStyle.DASHED);
- setBoaderStyle.setBorder(null, true, true, true, null, null);
- var setFormula = OCreport.getRange("E" + lastRow).setFormula("=IFERROR(VLOOKUP(D" + lastRow + ",nameConFig!$A$1:$B$63,2,FALSE),\"Select Rank\")");
- OCreport.setRowHeight(lastRow, 130);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement