Copy And Paste Values Using VBA

Hello,

I am trying to write a Macro where it will use date and time (protected fields), and copy and paste values for only fields that have a formula. I am almost there, but I keep getting a debug run time error 1004.

Please Login or Register  to view this content.

Thank you,

Daniel

I am now getting run time error '28':

Out of Stack space. When I select debug it shows the below line highlighted.

Please Login or Register  to view this content.

I have also attached the file.

Thank you,

Daniel

When you do the copy & paste, you are updating the worksheet and so the Worksheet_Change event is triggered again. The Sub is called again and again recursively until you run out of stack space. The way to prevent this is to turn off events while you update the sheet. See code below.

Also, do you want to do that copy and paste every time there is any change or only when column A changes? If the latter then you need to move your End If down farther, as shown.

Please Login or Register  to view this content.

Oh, that was perfect. Thank you, 6StringJazzer.

You're welcome! Thanks for the rep. To mark your thread SOLVED, go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."