In the VBA Object library, the Application object has a Union method. This method allows one to easily gather (non-)contiguous ranges into one collection. The Union method is smart enough to build c...
I've been working on my own version, which now works but is too slow to be practical. Happy to share if yo like to try. It needs rewriting so it uses less API calls and handles everything using arrays of indexes but I haven't had the time to do that yet.