=IsText Formula Not Updating?

[indi visual]

Range(Cells(2, 1), Cells(2, 1).End(xlDown)).Offset(0, 2).FormulaR1C1 = "=ISTEXT(RC[-2])"


It appears it updates at the very end of my code, but not fast enough in the middle when I need it to be accurate.


I've tried both

Application.ScreenUpdating = True

and

Application.Calculation = xlCalculationAutomatic


I think it might have something to do with me pasting the values in right before I check ISTEXT.


Is this my problem?

 

[Hui]

I've tried that with 200,000 mixed numbers and text values in Col A and it works pretty well instantaneously adding True/False to Column C


Can you post more of the code before this line ?

 

[indi visual]

http://www.iandmyself.me/Code.Portion.Above.txt


If take this out, the rest of my code beneath this works.


If I leave this in, the rest of my code beneath does not.


The problem is I actually need this code though.

 

[indi visual]

Nevermind on this I got it solved!


Thanks Hui, you helped me by letting me know nothing was wrong with that piece of code so I searched elsewhere for the problem.


I had too much going on before and after that true-false bit, so I simply rearranged my code and placed that piece somewhere and now everything works.


I know my questions are always challenging, but that's a good thing right?

 

[dan_l]

One day I actually want to learn what Indi is working on. I imagine all of his questions relate to a single workbook that dozens of quirks.