@Charles ,
Issues about VBA code are not supported on Q&A currently, please post a new question on Excel for Developers forum.
I would change the tag to be "not-supported". Thanks for your understanding.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.