Cut and paste without getting =#REFERENCE in depending formulas

[Marcus Ahlbäck]

Hi,

Lets say I have a value in A1 and a formula referring to A1 in B1
If i cut-and-paste a value from say A2 into A1 I get an error-message in B1.
Is there a way to avoid this? (I have already figured out that it works as I want if I do Copy-paste instead of cut-and-paste, but is there a better way?)

Best regards Marcus