So, I have this script that I had running, but modified to sort data into different sheets based on an input box. It works, and does everything I want it to, but now, every time I run it, a new instance of Excel runs in the background. As far as I can tell(and I don't really know much about this sort of thing), is that somehow the workbook is closing, but the worksheet is staying active. I've been looking up stuff and reading for hours trying to figure this out, am I at least heading in the right direction?? This is a basic script inserted into a PC DMIS program(outside of Excel). I have the changes I made to achieve the sorting process(2 paragraphs) marked with "worksheet input:
Bookmarks