Within the formula itself (not counting the quotes around the formula
used by the .Formula function) double up the quotes. For example,
notice the quotes around "text" versus the single quotes around the
entire formula:

range("A1").Formula = "=search(""text"",$B$1)"