//var newCell = activecell.offset(0, -2);
//getCell(row, column)  Range   Returns a given cell within a range.
//offset(rowOffset, columnOffset)

// The code below clears range C2:G8 in the active sheet, but preserves the format,
 // data-validation rules, and comments.
// SpreadsheetApp.getActiveSheet().getRange(2, 3, 6, 4).clear({contentsOnly: true});