Google Sheets script to find text in a range

Question

I am trying to find a script that will search a range ("B29:B28") for a string. The string will come from a variable, lets call it value. I will also be copying this, but for now lets just select it.

So:

function findText() {
  find(value in range("B29:B28")
  make cell containing text active
}

Obviously this code is just what I want, not any type of code.

Thanks for any help!

Brodieman · Accepted Answer · 2015-03-25 19:17:24Z

1

Best practice or not, this works:

  var rng = sheet.getRange(28, 2, 11, 1);
  var data = rng.getValues();
  var search = "What to search for"

  for (var i=0; i < data.length; i++) {
    if (data[i][0] == activeBill) {
      data[i][0] = "Sets found cell to this";
      rng.setValues(data);
    } 
  }

answered Mar 25, 2015 at 19:17

Brodieman

932 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Google Sheets script to find text in a range

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related