title: Excel VBA selecting multiple dynamic ranges
body: <p>I'm trying to selecting multiple dynamic range. Trying to use the union method and I'm getting Method 'Range' of 'object' Global Failed error on first Set line.</p>
  
  <pre><code>Dim LR As Long
  LR = Range("A60000").End(xlUp).Row
  
  Dim R1, R2, R3, R4, R5, MultiRange As Range
  Set R1 = Range("A7,:A" &amp; LR)
  Set R2 = Range("D7,:D" &amp; LR)
  Set R3 = Range("G7,:G" &amp; LR)
  Set R4 = Range("H7,:H" &amp; LR)
  Set R5 = Range("J7,:J" &amp; LR)
  Set MultiRange = Union(R1, R2, R3, R4, R5)
  MultiRange.Select
  Selection.Copy
  </code></pre>