A maco makes all my Vlookups and formulas disappear!!!!

Hi guys,
So I have this macro to multiply all any row in a workbook that has an X in column B by a coefficient I designate. The macro works but when I run it not only does it multiply the rows i want but it also makes all the vlookups and formulas in any other cell that does not have a X in column B disappear and just leaves the most recent number that was in the cell but no formulas or vlookup. How do I stop this from happening I am very confused. Here is the code.
Thank you everyone,
Your friend

Please Login or Register  to view this content.

HI thank you for the reply,
I tried it and yes it worked it multiplied the rows without breaking the other formulas however I get a debug error N.2042. I will put the line of code which causes the error below.
Thank you.
Your friend

Please Login or Register  to view this content.

hi is there a way you can help me. So I altered the above code a little and it works very well for for just converting from dollars to euros however I need to be able to go back from euros to dollars I have tried a few different methods but am coming up frankly short. For some reason it keeps multipliyng but weird numbers and I am just confused below is the code I have.
Thank you,
Your friend

Please Login or Register  to view this content.