Macro doesn't run with F5, but runs with F8--step by step

Please consider:
Be polite. Thank those who have helped you.
Click the star icon in the lower left part of the contributor's post and add Reputation. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Last edited by humdingaling; 06-12-2018 at 03:58 AM. Reason: typo - offending

If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Don
Please remember to mark your thread 'Solved' when appropriate.