Thanks guys!
Yeah, I guess the 'End' command is true to its name and pretty much ends everything haha.
My initial problem with using the 'Exit Sub' command was that since my application was so large, I had a lot of subroutine 'Calls' within a Main subroutine. Therefore, if the code reached an Exit Sub within one of these called subroutines, the application would just exit to the main sub, (which would then just call the next subroutine in the Main sub, which was not the desired result).
I got around this issue with a fairly simple solution, with a variable I named 'exitSub'. Right before a line containing 'Exit Sub' coding was reaching, I coded for the exitSub variable to = 1. The application would then exit the sub to the Main sub, but before the next sub was called I had the program check whether exitSub equaled 1 with an If statement. If exitSub = 0, all was good and the program would continue. However, if exitSub = 1, another Exit Sub would result and the application would also exit the Main sub.
Another option might have been to play around with the 'GoTo' command.
I guess the solution wasn't all that complicated, but it sure had me pulling out my hair when my arrays kept emptying!
Thanks again for everyone's help, I defiantly learned a lot about the End command with this trial!![]()
Bookmarks