Combining VBA code together

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.

Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

I am providing the link this time because you are a new user.

https://www.mrexcel.com/board/thread...-help.1255986/

In both cases you do not show the declaration of the Sub at the top of the code.

The code is very difficult to read because the variables are not declared, the variable names are cryptic, and there are no comments. Just speaking for myself it would take me way more time just to understand what this code does than I can offer for free. And that doesn't even get into how to combine them.

If the first sub is Worksheet_Change you can take the same approach as I have done below.

Here is a quick combination of the two Worksheet_SelectionChange events without needing to understand what any of it does. By doing analysis of the functionality it might be possible to make it more efficient or more readable. It's impossible to test without your file.

Please Login or Register  to view this content.