adding new case to code

[kriminaal]

I'm a newb at vb code and managed to get this macro together.
But now I have added some to another sheet and need to add this macro in the workbook.
This is my current code.

Please Login or Register  to view this content.

How would I add this one to it? I seem to be getting errors everytime I try.

Please Login or Register  to view this content.

thanks

[davesexcel]

What are the errors you are getting, that will give you an idea what is wrong.

[xladept]

Maybe:

Please Login or Register  to view this content.

[kriminaal]

Thanks, that seems to be working.
I should have clarified, that I meant I wasn't really sure how to add it into the original code.
The Application.EnableEvents=True was what I was missing.

thanks again

[xladept]

You're welcome and thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.