I think I have a corrupt file. Not sure.

[ProphetofProfit]

Here's why:

I run a macro.
Which takes a value from one sheet and pastes to another.
Let's make this value 1.5 and say it is pasted into A2
After some formulas, this value becomes 1.6 in cell D2.
D2 is then copied and pasted back to the worksheet where it came from.
A few rows down, this 1.6 is needed again.
So 1.6 is then pasted back into, say, A8.
But like magic, the 1.6 becomes a different number to what it should be.

And I mean by magic. Because there is absolutely no formula in my sheet (95% certain) that could turn 1.6 into 2.36 or whatever. I've had a 5 turn into an 8 which is what makes me so sure. The 8, couldn't have been accidentally pasted from another cell because the values don't get that high.

And the same macro works fine for 98% of the rows.

My worksheet crashed previously and became corrupted, so I had to repair it. Could this be the problem?

 

[Richard Schollar]

Please post your code - it is remarkably difficult for us to help with such limited information. Perhaps someone will spot a potential problem with the code. Please be explicit about which cells contain this changed number.

 

[ProphetofProfit]

Sorry, I'm retarded and believed in magic for a minute, when the problem was with the code I wrote. Please delete this thread to hide my stupidity.