title: How to select column O - AK using getRange in Google Scripts
body: <p>I have a spreadsheet contains list of activities, and I am currently making a calendar reminder which sends an email task reminder weekly based on current's week coverage (mon-sun), It has a <code>column header range of A - AL</code>, and <code>row range of 1 - 140</code>, What I want to accomplish is to select the <code>range of column O - AK</code> and <code>row 2 - 140</code></p>
  
  <p>here is some of my code:</p>
  
  <pre><code>var sheet = Spreadsheet.getSheetByName("TaskList");
  var dataArray = sheet.getRange("M2:P36" + sheet.getLastRow()).getValues();
  </code></pre>
  
  <p>here is the replicate of my spreadsheet, just to show you the rows and columns, there is also the g-script source and the settings sheet.</p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1sp5q51YgiuUksivl97AizXU2my05bI9dkxrp_w_hozo/edit?usp=sharing" rel="nofollow">https://docs.google.com/spreadsheets/d/1sp5q51YgiuUksivl97AizXU2my05bI9dkxrp_w_hozo/edit?usp=sharing</a></p>
  
  <p>you can test run it just change the email parameter to your email to receive the output, the 2nd sheet name is "Settings"</p>
  
  <p>I just want to eliminate the column "Date(Start)" and "Date(End)" in the range selection which is the columns M and N and start from column O to AK.</p>
  
  <p>Thanks in advance.</p>