Breaking News: Grepper is joining You.com. Read the official announcement!

Google sheets clearing cells

Lazy Ladybird answered on September 25, 2023 Popularity 6/10 Helpfulness 1/10

answer Google sheets clearing cells

Google sheets clearing cells

Comment

/// Clears a range of cells as defined in another cell
function ClearCells() 
{
  var sheetName = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getName(); 
  // Can also get the values from one sheet to remove on another if you want to split this into two
  // e.g. var controlSheet = SpreadsheetApp.getActive().getSheetByName('Control Sheet');
  var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);

  // Gets the number of cells to check as well as the position to check below
  var topCell = sheet.getRange('G36'); // G36 is the header cell of which other defined references to clear cells can be kept
  var numValues = topCell.getValue();
  var columnVal = topCell.getColumn();
  var rowVal = topCell.getRow();

  for (var i = 1; i <= numValues; i++)
  {
    var cell = sheet.getRange((rowVal + i), columnVal);
    var cellValue = cell.getValue();
    Logger.log("Clearing cells - " + cellValue);
    sheet.getRange(cellValue).clearContent();
  }
}

For the numValues, in that cell use put =COUNTA([cell column]:[cell row + number of values that might be below])

Popularity 6/10 Helpfulness 1/10 Language whatever

Source: Grepper

Tags: cells google-sheets whatever

Link to this answer
Share Copy Link

Contributed on Sep 25 2023

Lazy Ladybird

0 Answers Avg Quality 2/10

Google sheets clearing cells

Contents

More Related Answers

Google sheets clearing cells

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.