Okay, I see two little issues. The first is that when I step-thru it, when you change Calculation to Manual, the CutCopyMode appears to go to False (ie - there's no longer anything copied; like hitting the Esc button).

Anyways, the next thing is this:

Let's say the Value of I3 is 4.
Let's say the formula in I4 is: =I3 + 2

Now normally, if you just copied down, I5 would be: "I4 + 2", I6 would be: "=I5 + 2", and so on. So the cells would end up have the values (top to bottom) 6,8,10,12....

But with this way of skipping the formula, the cell just below the light turquise cell, would end up having the value of 2, as it is adding to zero (the value of the blank cell). Is that okay?

Mark