Copy -- Paste Special -- Values

"Zack" wrote:

Generated new columns by formulas, but now when merging with an existing
workbook, I get this #REF entry due to the fact that the formula is not
there any more. What is the solution around this hiccup?