Combine 2 sets of code

[muleymuel]

Dear all,

i have two different groups of coding, both of which work perfectly by themselves however i am unable to get them to both work side by side.

The first set was written by someone who knew what they were doing, the second set was scrabbled together with what help i could find from Google (so it probably isnt the best way it could be done)

With your infinitely greater knowledge of VBA, can anybody assist me with combining the following two sets of code correctly?

Please be gentle




First set:

Please Login or Register  to view this content.

-------------------------------------------------------

Second set:

Please Login or Register  to view this content.

[Andrew-R]

If you take out all the lines that start with "Application.EnableEvents" in the first block of code then that should be it.

Edited to add: If you put an apostrophe at the start of those lines it will comment them out - that might be easier.