Is there a way that I can paste values into a column and not have my worksheet recalculate? I need the source values (those that are copied) and the pasted values to remain the same. The values in the source column are dependent upon cells in another column that are randomly generated. The act of pasting causes the source values to recalculate; hence the mismatch. Setting calculation mode to manual creates another set of problems for me.