Help on modify existing VBA to allow comparison of 2 text cells to work

[ItalianPlatinum]

Hello - running into an annoying problem where my comparison of two columns doesn't work when I check for a simple true/false statement. I am comparing Column K to Column U with formula K13=U13, data is the same but says false.

Column K (format of row K is TEXT)

Column U

    .Range("U13:U" & lr).NumberFormat = "General"
    .Range("U13:U" & lr).Formula = "=IFERROR(VLOOKUP(D13,'NAS D'!$A$6:$Y$10000,8,0),"""")"
    .Range("U13:U" & lr).NumberFormat = "@"

even if i do a sample test it doesn't work - but does if i click into column U. how do I get VBA to do the same and click into each cell to get it to work? To note data set is LARGE over 10k rows. so clicking into each cell would kill performance. any help is appreciated. thanks in advance.

 

[ItalianPlatinum]

Thanks Peter. I will also give that a try.