Syntax wrong in sort script?

Question

Writing a script to sort a sheet by a range , A4 to the bottom right cell (because rows and/or columns may be added). The script finds the cell of the last column/last row and then uses that in the range var. Problem is when I try to run this script it gives me "Missing ) after argument list. (line 8, file "Sort By Gamer Tag")". But I've closed all the "(".

Any advice?

Thanks

function sortByGamerTag() {

  var ss=SpreadsheetApp.getActiveSpreadsheet();
  var sht=ss.getSheetByName('Master Summary 2');
  var lastRow=sht.getLastRow();
  var lastCol=sht.getLastColumn();
  var lastCell=sht.getCell(lastCol,lastRow);
  var range = sht.getRange("A4":lastCell);
  range.sort(2);

}

Tanaike · Accepted Answer · 2017-06-27 01:44:50Z

1

I think that there are 2 modification points in your script. Please confirm below.

Modification points :

range of getRange(range) can be given by strings.
- So please change from "A4":lastCell to "A4:" + lastCell.
getCell() returns a given cell within a range. (Ref.) In your script, an error occurs at var lastCell=sht.getCell(lastCol,lastRow);.
- So please change from var lastCell=sht.getCell(lastCol,lastRow); to var lastCell = sht.getRange(lastRow, lastCol).getA1Notation();.

Modified script :

Your script can be written by modifying above points as follows.

function sortByGamerTag() {
  var ss=SpreadsheetApp.getActiveSpreadsheet();
  var sht=ss.getSheetByName('Master Summary 2');
  var lastRow=sht.getLastRow();
  var lastCol=sht.getLastColumn();
  var lastCell = sht.getRange(lastRow, lastCol).getA1Notation();
  var range = sht.getRange("A4:" + lastCell);
  range.sort(2);
}

If I misunderstand your question, I'm sorry.

answered Jun 27, 2017 at 1:44

Tanaike

203k12 gold badges126 silver badges222 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Don Beasley Over a year ago

no you understood perfectly. Thank you for explaining. I had not thought at all about the A1 Notation. Thank you.

Tanaike Over a year ago

Welcome. Thank you, too.

Collectives™ on Stack Overflow

Syntax wrong in sort script?

1 Answer 1

Modification points :

Modified script :

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Modification points :

Modified script :

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related