Running a macro stops a formula from functionning

[clemlcfc]

I had the same problem earlier with another macro and now it is with a new one but i can't figure out how to make it work.

So basically the problem i'm having is each time i run the macro the formula in the previous column is deleted :

Please Login or Register  to view this content.

how can make the macro not delete the formula ?

here is the complete file :VLOOKUP help (1) (1).xlsm

[sintek]

Please Login or Register  to view this content.