1. Why did you not post the code directly to the forum?
Use code tags around code.
Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the
# icon at the top of your post window. More information about these and other tags can be found
here
2. Why did you not post a sample workbook with enough sample data to test the macro?
Bookmarks