title: xlwings using api.autofill how to pass a range as argument for the range.autofill method
body: <p>I can easily fill a column with formulas on Excel using VBA and the range.autofill method:</p>
  
  <pre><code>Range("A2").AutoFill Destination:=Range("A2:A10"), Type:=xlFillDefault
  </code></pre>
  
  <p>This will take the formula/content on cell A2 (or a range) and expand it to A10.</p>
  
  <p>Looking at the MSDN help I see: <a href="https://msdn.microsoft.com/en-us/library/office/ff195345.aspx" rel="nofollow noreferrer">https://msdn.microsoft.com/en-us/library/office/ff195345.aspx</a></p>
  
  <p>and: <a href="https://msdn.microsoft.com/en-us/library/office/ff838605.aspx" rel="nofollow noreferrer">https://msdn.microsoft.com/en-us/library/office/ff838605.aspx</a></p>
  
  <p>On xlwings I can do:</p>
  
  <pre><code>import xlwings as xw
  rp = xw.Book(myFile)
  rp.sheets('mySheet').range('A2').api.autofill(range, 0)
  </code></pre>
  
  <p>But I do not know how to pass <code>range</code>. I cannot simply type "A2:A10", I need to pass a range object. </p>
  
  <p>I tried to do: <code>rp.sheets('mySheet').range('A2').api.autofill(rp.sheets('mySheet').range('A2:A10'), 0)</code> but this simply blew Python!</p>
  
  <p>Any ideas? Thanks!</p>