You can paste at multiple places when for example you select the first range, then press CTRL & Select a second range with the mouse and then PASTE. You see that the PASTE operation is done for both selected ranges.
@phoenixhuynh09 Thanks, but are you sure that your code is correct? It seems you wanted to use "Select" and not "Switch"
Also I think we can rewrite it without using such long statements