[Solved] ERROR Find (p, q, r) in column (T) with formulas

[Math]

I already have the solution to find "p", "q", "r" in the "T" column and write "x", "y", "z" in column "M", in the macro Sub strangeAgain() sr. Lupp , in the topic: viewtopic.php?f=20&t=96017&sid=df6c1b34 ... 8d67f60034

                 I ran tests on the spreadsheet without formulas in the "T" column, worked perfect for Finding "p", "q", "r" in the "T" column that has no formulas .

                 Now I was applying the macro in my file holder, which has formulas in the "T" column, the macro did not work , to locate in the "T" column that has formulas .

                 The macro does not see the letters "p", "q", "r" resulting from formulas in the "T" column .

                 I did several tests, and did not read the "T" column that has formulas .


hugs friends

[Lupp]

This won't lead anywhere. If you insist on using "macros" you need to learn to understand them.
As far as I can remember you didn't mention that your texts (probably being "p" ...) are/may_be formula results. In this case the only reasonable solution is to abandon using "macros" for the task and to use formulae instead.

How to do so, see column M in the new attachment. The reworked "macro" used for column AA is very inefficient for large source ranges (1048576 rows in my example) and cannot avoid inconsistencies if the formulae used in column T can contain volatile functions. If it shall be updated after recalculations of column T the inefficiency will get terrible.

Stick to means you understand. Concerning details you are welcomed with your questions and will get kind answers. Going on the way you chose would only result in wasted time. NEVER AGAIN TRY TO "CONVERT" SILLY EXCEL_VBA MACROS. It's the wrong way. In my opinion also Excel users are encouraged to use macros mainly as a part of MS' fight against free competitors because it's a well proven way to ensure incompatibility. I will no longer support this.

I had to clip the example to get it uploadable.

[Zizi64]

[Math]

[SOLVED]

sr. Lupp ,

the macro performed perfect .

Many thanks, my friend .

hugs

[Lupp]

...the macro performed perfect .

I feel sure this will soon turn out to be an illusion. You should really consider the relevant suggestions you got from more than one contributor here, how to work with Calc.