What is it with people lately, wanting a modeless UserForm and clinging to procedural paradigm?
I'd re-post this answer, verbatim. You absolutely want vbModeless, and definitely split up your procedures. The less a procedure does, the better. — Mathieu Guindon33 mins ago
Duck check: At times when I'm at the base of a call stack and the current method exits there are other methods that may be called after. Currently an OnPropertyChanged handler just got invoked. Is this an example of listeners which are subscribed to an event firing now that something has occurred?
This code is tested and works, but I am needing some guidance on simplifying these loops with non contiguous ranges. I was thinking an array might be better, but I havent had enough experience with Arrays to know where to start with one. Any guidance would be greatly appreciated.
Dim r As Rang...