Sep 22 2022
I am using `Range.Find` in my macro, and I noticed that `LookIn:=xlFormulas2` is only supported in office365.Thus, I have to change my codes from `LookIn:=xlFormulas2` to `LookIn:=xlFormulas`.
What I am wondering is that what's the differences between these two.
I've found the explanation page between Formula and Formula2 in the following link.
Do `LookIn:=xlFormulas` and `LookIn:=xlFormulas2` use `Range.xlFormulas` and `Range.xlFormulas2` respectively?
As I understood, despite of the fact that they are implemented by different algorithm, these two args will only result in speed difference when using `Range.Find`.
Am I right?(I found that LookIn:=xlValues are actually getting Range.Text, so I would like to want to get some confirmations...)formula vs formula2:
https://learn.microsoft.com/en-us/office/vba/excel/concepts/cells-and-ranges/range-formula-vs-formul...Lookin API (which does not mention xlFormulas2?):
Aug 03 2023