help copying over vlookup formulas without creating link

I have a spreadsheet that contains a roster of names and next to each name is a vlookup. Whenever I update the roster I run a macro that copies the updated roster to several of my employee's own workbooks. Worked fine except now that I've added the vlookup the formula points them all back to my workbook. Only method I know would be do a find/replace that exact text out. It will work but I just tried it on one workbook and it took 5 seconds. I need to do this to ten workbooks.

I've uploaded what my workbook. My team looks the same as well.

Please Login or Register  to view this content.

If I add this find/replace code into my macro it doesn't work. it does if I run it separately.

Please Login or Register  to view this content.

Thank you. that might work, but I can't put that formula in every cell. Does your code only replace formulas? I have other formulas on my worksheet in addition to the vlookup.

Ok magic man. how did that work? Does that just copy any and all formulas on my sheet? Doesn't matter what formula?