title: VBA drag formula from left to right
body: <p>I am trying to drag a formula from a cell to another cell to the right (i.e. <code>cellA1 [formula: A2 + A3] -&gt; cellB1 [formula: B2+B3])</code>. Here is what I have:</p>
  
  <pre><code>Dim lastColumn As Long
  lastColumn = Workbook2.Worksheets(7).Cells(1, Columns.Count).End(xlToLeft).Column
  
  cellSource = Workbook2.Worksheets(7).Cells(3, lastColumn)
  cellTarget = Workbook2.Worksheets(7).Cells(3, lastColumn + 1)
  
  cellSource.AutoFill Destination:=cellTarget, Type:=xlFillDefault
  </code></pre>
  
  <p>Error is "Object Required"</p>