Jul 12 2022 06:52 AM
For some reason I added some code to my vba that I thought would speed things up but now the code sometimes freezes (30 seconds and eventually finishes) when running and other times not even though I am doing the exact same work and data entry on different workbooks formatted to use the same code
Application.ScreenUpdating = False
Application.DisplayAlerts = False
then later I set these to True.
I have some popups going in the code as well where I have to click ok to close them but they seem to show up after the code is ran.
Jul 12 2022 11:19 PM