Guest User

Untitled

a guest
Jan 23rd, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.98 KB | None | 0 0
  1. function onOpen(e) {
  2. DocumentApp.getUi()
  3. .createMenu('Copy active Range.')
  4. .addItem('Copy Button', 'Copy')
  5. .addToUi();
  6. }
  7.  
  8. function Copy() {
  9. var ss = DocumentApp.getActiveDocument();
  10. var selection = ss.getSelection();
  11.  
  12. var tss = SpreadsheetApp.openById("xxx");
  13. var ts = tss.getSheetByName("name");
  14.  
  15. trange = ts.getRange("B6:B6")
  16. selection.copyto(trange);
  17. }
  18.  
  19. var SPREADSHEET_ID; // = assign your spreadsheet id to this variable
  20. var SHEET_NAME; // = assign your sheet name to this variable
  21.  
  22. function onOpen(e) {
  23. DocumentApp.getUi()
  24. .createMenu('Copy active Range.')
  25. .addItem('Copy Button', 'Copy')
  26. .addToUi();
  27. }
  28.  
  29. function Copy() {
  30. var ss = DocumentApp.getActiveDocument();
  31. var selection = ss.getSelection();
  32.  
  33. var tss = SpreadsheetApp.openById(SPREADSHEET_ID);
  34. var ts = tss.getSheetByName(SHEET_NAME);
  35.  
  36. trange = ts.getRange(2, 6); //I think, you can use B6 also
  37. trange.setValue(String(selection));
  38. }
Add Comment
Please, Sign In to add comment