TypeError: Cannot call method “getRange” of null. (line 14, file “Code”)
The error means
null doesn’t have a
getRange method. Only a real
Sheet class does.
As written in the documentation, There is only one reason, where the
sheet returned is
Returns null if there is no sheet with the given name.
There is only one answer. It’s when that sheet name doesn’t exist.
sheet name refers to the tab name in a spreadsheet/workbook. It does not refer to the filename or document name. By default, the first sheet/tab is named “Sheet1”. Try
If you still have trouble getting the sheet, check for spaces, non printable characters in the sheet name. Alternatively, Rename the sheet to something simple like