extrobe
2/17/2017 - 12:55 PM

Get the last used row in a sheet

Get the last used row in a sheet

function GetLastRow () {
//the GUID for the file we want to work with
 var ss = SpreadsheetApp.openById("1KE801BupgO1B_aR_PxpqoqmOgE8f2usAY");
  
//Copy & Paste columns Z to AA  
  var lr = ss.getSheetByName("Target Customers").getLastRow();
}