Looping Copy/Paste Macro

Hi yuuuh

I'd like to create a macro that copies one cell of a range, pastes that cell on another sheet, then clears the cell pasted into. Takes the next cell in the range, and then copies it into that same cell previously used.

OK, I'll bite. You're copying a cell, pasting, deleting the paste, copying a cell, pasting, deleting the paste, etc, etc, etc.. Correct?
Why? What's the purpose? It'll help if I know your end goal.
John

Exactly. The cell being pasted into is referenced in an equation, so when the new paste occurs, a value changes. I would like to be able to control when the next copy occurs via a key, so that the value can be observed. Not sure if that makes sense, basically to see the impacts of user defined values on an equation.

Hi yuuuh
OK, that makes some sense. I think I can help you with this. However, if you could post some sample data with the results, it'll help me see if things are calculating correctly. Not a "must" just may save some aggravation
John

For sure, here's a simple sample.

Hi yuuuh
Try this code

Please Login or Register  to view this content.

Let me know of issues
John

yuuuh, please don't quote whole posts. It's just clutter.

Hello yuuuh,

You should read about Scenarios in Excel. Scenarios allow you to select specific cells to be changed and observe the results on the remaining data.