 <p>You can't copy a range with more than one area. You will have to transfer the data over one range at a time. Using <code>Range.Areas</code> you can see that you have multiple areas in multipleRanges.</p>