Combining Two macros into one.

[Tubtech]

I have these two macros, they work alone, however is there a way to combine them so they work as one? In addition I have 24 sheets in this workbook I would like the macro to work on all of them depending on what sheet is in use. Thanks.

Please Login or Register  to view this content.

[6StringJazzer]

They are unrelated so you can just merge the code.

You could also keep them separate, and create a third Sub:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

That line is just going to give you ActiveSheet.

Here is the merged version:

Please Login or Register  to view this content.

[Tubtech]

Thanks For the help ! learnd something today!

[6StringJazzer]

Glad to help!