Hello everybody, I am having a problem and can't seem to chase it down. I have a macro that builds out a range on another worksheet for a larger overall procedure. If I run this macro out of the VBA window it runs in less than a full second but when I run the main routine this sub runs much much longer. However, if I click anywhere in excel during the longer run time, I get the "not responding" fade for excel, and then immediately the sub pushes through and completes.
I do expect a slightly longer run time as there is more being done when it's called in the routine as opposed to alone, but I cannot understand why just this one sub causes the hang up and why trying to interrupt fixes it. This was built in Excel 2010 and did not experience that issue, however since we have switched to 2016 this has began along with other overall performance issues.
Any suggestions or ideas are much appreciated.
Thanks
Bookmarks