Guest User

Untitled

a guest
Feb 20th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. function insertCopiedCells() {
  2. var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  3. var copyRange = spreadsheet.getActiveRange();
  4. var copyRangeRows = copyRange.getNumRows();
  5.  
  6. // This is where I want to select the range with a mouse selection
  7.  
  8. var pasteRange = spreadsheet.getRange(rangeSelection);
  9. var pasteRangeRow = pasteRange.getRow();
  10. pasteRange.activate();
  11. spreadsheet.insertRowsBefore(pasteRangeRow, copyRangeRows);
  12. copyRange.copyTo(pasteRange);
  13. }
Add Comment
Please, Sign In to add comment