title: AutoFill error in excel c#
body: <p>The error statement says "Unable to get the AutoFill property of the Range class". However, AutoFill property is indeed in Range Class, as I checked.  Does anyone know how to resolve this error?
  I have tried search in google, and there's no approperiate answer to this. Also I have tried convert the code in VBA, and it works fine in VB. </p>
  
  <pre><code> using Microsoft.Office.Interop.Excel;
   Application.Range["H2"].Select();
   Selection.AutoFill(Destination: mdlAMain.xlApp.Range["H2", "H" + myRow],
                                           Type: XlAutoFillType.xlFillDefault);
  </code></pre>