Is there code that can be added to the end of a macro that will change the formulas to values? Im copying from another workbook, and the things im copying are references to other cells. Once I copy them into this workbook with my macro, I no longer want them to be references. I want them to be values, so they will not change when the other workbook changes. Thanks