resolverange.js

// Deal with column vs range select
function resolveRange(sheet) {
  let range = sheet.getActiveRange().getA1Notation();
  let [first, second] = range.split(':')
  if (!/\d/.test(second)) {
    range = `${first}1:${second}${sheet.getLastRow()}`
  }

  return range
}