Skip to content

Instantly share code, notes, and snippets.

@oshliaer

oshliaer/Code.gs Secret

Last active February 5, 2019 14:47
Show Gist options
  • Save oshliaer/fdad6b4aab6dca4f0409640e09a4a6e6 to your computer and use it in GitHub Desktop.
Save oshliaer/fdad6b4aab6dca4f0409640e09a4a6e6 to your computer and use it in GitHub Desktop.
Clear out of datarange ranges. facebook.com/groups/googleappsscript
// Any sheets iterator here ----- START
clearOutOfDataRange_(sheet);
// Any sheets iterator here ----- END
function clearOutOfDataRange_(sheet){
var lR = sheet.getLastRow();
var lC = sheet.getLastColumn();
var mR = sheet.getMaxRows();
var mC = sheet.getMaxColumns();
if(mR > lR)
sheet.getRange(lR + 1, 1, mR - lR + 1, mC).setBackground('#FFF');
if(mC > lC)
sheet.getRange(1, mC - lC + 1, mR, mC - lC + 1).setBackground('#FFF');
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment