title: Define a range using an existing named range & offset/resize
body: <p>I am trying to use an existing named range to reference different rows (the columns should be the same). Right now I have the following:</p>
  
  <pre><code>Dim DetailONE, DetailONW, DetailW, DetailQc As Range
  Set DetailONE = Sheet11.Range("CM12:EG13")
  Set DetailONW = Sheet11.Range("EI12:GC13")
  Set DetailW = Sheet11.Range("GE12:HO13")
  Set DetailQc = Sheet11.Range("HQ12:IT13")
  </code></pre>
  
  <p>And then I refer to those named ranges but I get an Application defined or object defined error with the following. Does anyone know why? I don't know if I need the .Address part afterwards either or if I can forego this.</p>
  
  <pre><code>Dim OntarioWestDet, OntarioEastDet, WestDet, QuebecDet As Range
  Set OntarioWestDet = Sheet11.Range(DetailONW.Address).Offset(3, 0).Resize(300, 0)
  Set OntarioEastDet = Sheet11.Range(DetailONE).Offset(3, 0).Resize(300, 0)
  Set WestDet = Sheet11.Range(DetailWe).Offset(3, 0).Resize(300, 0)
  Set QuebecDet = Sheet11.Range(DetailQc).Offset(3, 0).Resize(300, 0)
  </code></pre>