Search parameters to find inside formulas

I use this line to search for a chain or a digit in the sheet

Please Login or Register  to view this content.

and it works fine; but in cells with formulas it doesn't search inside the formula; only in the total value.
Which parameter must I change so it will search also inside the formula?
I've tried xlFormulas in place of xlValues; but then it searches only inside formulas skipping other cells

Thanks for any help

Can you give an example of what you are trying to achieve?

As an idea, you can combine the searches: try to search in values, and then in formulas. If any of the results returns a range, you can then activate this range.

Something like this:

Please Login or Register  to view this content.

Ah, ok.

It actually appears that you can search in both formulas and values at the same time. Just omit the LookIn parameter in your code:
Before

Please Login or Register  to view this content.

After

Please Login or Register  to view this content.

If your ranges are located next to each other, you can combine them using Union method in VBA. Otherwise I guess you will need to copy (or perform whichever action you need) in a loop.
Please review the following code sample. It highlights all cells where either formula or text contain valueToSearch.

Please Login or Register  to view this content.