Search parameters to find inside formulas

[aca]

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

[rpieuhtyelnekpmduz]

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.

[aca]

Thank you for this contribution
What I try to achieve? Just to be brought to the cells containing the word or the numbers for a variety of purposes: copy them, replace, delete them etc.
Your suggestion of using the two kinds of searching, one after the other is certainly very useful if one and the same cannot look both at the cell and inside the formulas. Thank you for that.
aca

[rpieuhtyelnekpmduz]

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.

[aca]

Thank you very, very much: that works worderfully. Exactly what I needed.
I add to your reputation with enormous pleasure.
aca
I'd like to mark this post "Solved" but I don't know how to do that.