Skip to content

Instantly share code, notes, and snippets.

@rodrigomojeda
rodrigomojeda / SearchString.gs
Created March 14, 2019 14:33
Searches for a string in a Google Sheets sheet.
/* Searches for a string in a sheet*/
function searchString(stringToSearch,sheetName) {
var sheet=SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);
var selection=sheet.getDataRange();
var columns=selection.getNumColumns();
var columnsnames = selection.getColumn()
var rows=selection.getNumRows();
for (var column=1; column < columns; column++) {
for (var row=1; row < rows; row++) {
var cell=selection.getCell(row,column);