Oh, also, sometimes when it is giving the correct value, it is pasting
the original formula from the source column, but the cell references
have changed.

Thanks!
Aimee