Formulas are displayed as 'Text'

[AnkeK]

See attached test document


If I use the macro, the formatting in the new columns (D:E,R) is incorrect. When I use the VLOOKUP formula in the macro, this formula is displayed as TEXT instead of showing the result.
Can someone help me with a solution?

Thnx in advance!

[romperstomper]

I don't understand what you mean. Your code doesn't use formulas anywhere that I can see.