Copy Contents from one worksheet to another

[Kizinti]

Greetings, first timer so be gentle,
I have a spread sheet that uses a worksheet_change macro. I would like to either create a second macro, or in the same macro when the changes are implimented, copy the contents on the row that was changed (A-J) onto the last available line of an "ARCHIVE" page (i.e. a change tracker page).

The attempts I have tried so far capies the contents 607 times??? What am I doing wrong? Any suggestions.

Thanks,
Kizinti

 

[Von Pookie]

What is the code you are currently using?

 

[Kizinti]

To all,
I figured out the problem. In the Worksheet_Change Macro, I make changes to target cells. What I did not realise that whenever a change was made in the target range specified, the macro is called. Thus I was making chages, the macro was making changes, that called itself, etc, etc, etc.

A simple boolean flag that said, "if blnflag = True Then Exit Sub" fixed it. In the Macro, blnFlag was set to True while it was running, until the end where it was set back to False.

All I can say is "DOH!" <SMACK>

 

[Von Pookie]

If that's the case, all you need to use is Application.EnableEvents=False at the beginning of the code and then set it to True at the end

 

[Kizinti]

I did try that, but for some reeason my chages where not being done. When I put in the boolean flag, The changes were made, but the copy was done only once. Thanks though