sorting - Google Sheets script to sort table gives error "Cell reference out of range" -


i'm relatively new scripting in google sheets , trying write can assigned button sort table column 5 in table. using code below:

    function sort() {        var ss = spreadsheetapp.getactivespreadsheet();        var sheet = ss.getsheetbyname("items");        var range = sheet.getrange("j2:o13");        range.sort(5);     } 

however, when assign button , click button, error message "cell reference out of range". may stupid question in advance.

seems trying sort on col 5 (e) not in range. first column in range col 10 (j). if want sort on col o you'll need

range.sort(15) 

Comments