copy cell from one cell to another

[DVP2010]

Hi,

I have a quite easy problem but seem not to be able to get to it:
In a spreadsheet, I would like that the value that is (manually) entered in B3 is repeated in cells K9, 10, 11, 12, 13.
Also, I would like that the value that is entered in G9 is repeated in H9, in G10 in H10 until G13 in H13.
I need to do this via VBA because I am using a macro that allows to clear the content in K and H.

Any help with this would be great.

Thanks.

[Arkadi]

I suggest a worksheet change event?

In the VBA editor, double-click the sheet name that you want to do this in. Then paste this:

Please Login or Register  to view this content.

[DVP2010]

Thanks. Works perfectly. Only that G takes its value from a formula which means it will not repeat the value in H which I understand is a common problem (I have another thread on this on actually).Anyway, thanks a lot for the fast help

[navialivad]

If I understood correctly, the code below should be able to do it

Please Login or Register  to view this content.

[Arkadi]

DVP, worksheets also have calculate events, unfortunately I am not sure how to limit the scope of that process, since there is no "Target". But you could add this as another sub in your worksheet, where you put the change event (inefficient as it runs on every formula calculation on the sheet):

Please Login or Register  to view this content.

[DVP2010]

Thanks. This works in principle, i.e. the value in G9 is repeated in H9, however excel immediately freezes. Here is the code I am using on the worksheet:

Please Login or Register  to view this content.

[Arkadi]

I can't reproduce your problem on my end, of course I don't have the same workbook, but try changing the calculate macro to this and see if it helps? It should disable calculation during the update, maybe too much is happening at the same time...

Please Login or Register  to view this content.

[DVP2010]

Thanks. That does not work either unfortunately. Maybe because the formula in G is a vlookup (actually index match) and not a calculation?