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.
- Hi Hans,
Can't explain it either. I created a new worksheet, copied the raw-data in. Moved the formula,
3 to the right: Oké.
5 to the right, Oké.
3 to the right, Oké.
7 to the LEFT bingo error in the second part of the formula where I try to determine the number of empty cells, to create the correct output.
But normally I would only move the formula to the right.
In this case I wanted to reproduce the error.
Kind regards, Eddy - 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 EddyI don't doubt your experience, but I cannot explain it.
