I use a macro to send out emails, I am using this approach:
Everything works fine, except that after the email is sent Excel will freeze. It is only the things that are visible in the document that are “frozen”. If I scroll down or switch sheet, it will update the screen.
For example if I delete a row, it will delete the row but not show it on the screen. If I switch to another sheet and back again, it will show the row has been deleted.
Is this some kind of memory problem or what can cause this?
I am using the latest version of Windows 10 (1903 i believe) and latest version of MS Excel.