title: Offset and resize with vba
body: <p>I am having some problems with what I think is a simple vba command:</p>
  
  <pre><code>Worksheets("Sheet").Range("namedrange_d").Resize(0, 4).Offset(6, 0).Copy _
    Destination:=Worksheets("Sheet1").Range("namedrange").Resize(0, 4).Offset(6, 0)
  </code></pre>
  
  <p>I want to copy a defaults range 5 cells wide, that is 7 cells below a reference cell (<code>namedrange_d</code>). What is the problem with the syntax?</p>