title: VBA autofill down using a named range as destination
body: <p>Very simple question - exactly as the title says. I have searched thoroughly and can't find the answer anywhere. </p>
  
  <p>I have a formula in range("D3").  I have a named range called "copyrange", which is a single cell in column D, below D3. I want to autofill D3 down to all the cells down to and including "copyrange". </p>
  
  <p>I presume it's some variant of:</p>
  
  <p>ws.Range("D3").AutoFill Destination:=ws.Range("D3:copyrange"), Type:=xlFillDefault</p>
  
  <p>but I can't work out the syntax. </p>
  
  <p>Thanks in advance for any help. </p>