How to get the correct range to set the value to a cell?

by

The following code does what is required

function doTest() {
  SpreadsheetApp.getActiveSheet().getRange('F2').setValue('Hello');
}

More Related Contents:

  1. Moving google apps script to v8 file upload stopped working from sidebar
  2. How do I make a Sidebar display values from cells?
  3. Google Spreadsheet SCRIPT Check if edited cell is in a specific range
  4. No permission to call msgBox in Google Apps Scripting
  5. Custom functions intermittently hang with “Error – Loading Data”
  6. How to define global variable in Google Apps Script
  7. Periodically refresh IMPORTXML() spreadsheet function
  8. Export (or print) with a google script new version of google spreadsheets to pdf file, using pdf options
  9. Format a Google Sheets cell in plaintext via Apps Script
  10. UiApp has been deprecated. Please use HtmlService instead
  11. Google app scripts: email a spreadsheet as excel
  12. Is there a way to keep two sheets synchronized?
  13. Selecting the last value of a column
  14. Google apps script to email google spreadsheet excel version [duplicate]
  15. How to get filtered values from Filter after using setColumnFilterCriteria?
  16. GAS “On edit” trigger not running when edited from API
  17. Measurement of execution time of built-in functions for Spreadsheet
  18. onEdit() doesn’t catch all changes
  19. Google Spreadheets Scripts: check if cell is empty
  20. Custom Functions with add-ons?
  21. How to prefill Google form checkboxes?
  22. Converting .xls to google spreadsheet in google apps script
  23. Use script in all spreadsheets
  24. Iterate over range, append string to each
  25. Can the google spreadsheet ‘query’ function be used in google apps script?
  26. How to pause App Scripts until spreadsheet finishes calculation
  27. Custom Functions and Recalculation
  28. How to create INDIRECT array string of multiple sheet references in Google Sheets?
  29. Can the google spreadsheet ‘query’ function be used in google apps script?
  30. google script openById : You do not have permission to perform that action

Leave a Comment