How do you combine these TWO "Worksheet_Change" Call Macros into one?

[Ourkid123uk]

Can you combine multiple worksheet change events based on independant cell changes. I've included the two macros below which I need to combine into one:

Please Login or Register  to view this content.

Also the second part doesn't work correctly;

Please Login or Register  to view this content.

What am i doing wrong? I just need to Call the Macro when Cell F4 = "00:00:05"

[leelnich]

Assuming you only want to paste if cell F4 changes:

Please Login or Register  to view this content.

If you're changing cells, set Application.EnableEvents = False to avoid processing a second change event.

[Ourkid123uk]

Thanks for your reply!

Ok, so first parting working correctly. Second part doesn't. In Cell F4 it is a formula which gives me a countdown. Im guessing because its a formula and NOT a entered change it wont run the PASTE_VALUES macro? How can i get that to work?

[leelnich]

What events cause the formula to count down? Maybe you can respond to those. Perhaps the Worksheet_Calculate event would work. Alternatively, if you want Excel to call a macro at a set time (or after a set interval), use Application.OnTime.