Copy paste values on cell change in range

[PingTing]

I have a range (F13:AC300) that contains formulas. If any one of these cells is overwritten (ie. user input), I want to copy paste a different range (D13#) over top of itself. I have the following code but it doesn't work when I change on of the cells in the range. What do I need to do?

Please Login or Register  to view this content.

I have entered this at the worksheet level. Later on, I will be recreating this setup on a separate sheet, and I will reapply this technique to the new sheet.

[Mumps1]

Place this macro in the worksheet code module.

Please Login or Register  to view this content.

[ByteMarks]

Doesn't that get triggered even if the overwritten value/formula is the same as the original - i.e. no change?

[PingTing]

Thanks, Mumps1. That worked with some minor changes. I did the following;

Please Login or Register  to view this content.

Question: how do I now stop the macro running? Basically once it runs once, I want to not have it run again. I did "On Error Resume Next" but then it kept moving the active cell to D13. I definitely don't want that. I want it to just do the default Excel action. For example, once it's run and now the copy/paste has occurred, and I say do 5->Enter in cell K9, I want it to move to K10. Or if I hit Tab from K9, I want it to move to L9.

Thanks in advance.

[Mumps1]

Try:

Please Login or Register  to view this content.

[PingTing]

Worked perfectly. Thanks, Mumps1. One last thing; the first time I change one of the cells, it does the copy/paste but leaves like the picture below. How do I stop that?

Attachment 736631

[Mumps1]

Your link doesn't work. See the yellow banner at the top of this page for instructions to attach a file.