Deactivating Copied Cell after it is Pasted

Hi all, first the code and then then the question

Please Login or Register  to view this content.

This works well enough so that the value at

Please Login or Register  to view this content.

has the same formula in it but, I don't want the cell at

Please Login or Register  to view this content.

to continue being copied once these two lines of code are run. Because I don't really know how to phrase this, I'll just say that I want to deactivate the copied cell once finished. Any ideas?

Thanks all

Please Login or Register  to view this content.

I think is what you mean.