Forum Discussion
Problem with moving formula to new column
Problem with moving formula to new column, it affects the next formula in the same row. Which makes the second formula incorrect! Current formula: "=(CW786-BS786)/(AANTAL.LEGE.CELLEN(BS786:CW786)+1)...
I can't reproduce the problem.
If I use Shift+Delete and Shift+Insert or Ctrl+X and Ctrl+V to cut and paste, the formula remains exactly the same: the cell references are unchanged. This also holds if I simply drag a cell three columns to the right.
If I use Ctrl+C and Ctrl+V to copy and paste, all cell references are shifted 3 columns to the right.
Hallo Hans,
Thanks for your reply.
I doesn't resolve my problem, but i'm not telling story's it actually happens, and don't know why.
Sometimes it's oke, but most of the times I have to go and correct the second formula, why? Don't know. Dos speed of the processor - busy processor influence this, can't imagine, but its a computer!
Kind regards Eddy
Thanks for your reply.
I doesn't resolve my problem, but i'm not telling story's it actually happens, and don't know why.
Sometimes it's oke, but most of the times I have to go and correct the second formula, why? Don't know. Dos speed of the processor - busy processor influence this, can't imagine, but its a computer!
Kind regards Eddy
I don't doubt your experience, but I cannot explain it.